AD 2007-04-19 R1

Registered aircraft · 108,434

Registered aircraft whose airframe or engine model this AD names, by N-number. Matched by model only, so check each against the AD’s applicability.

Query with SQL
duckdb -csv -c "SELECT n_number, serial_number, year_manufactured, status, aircraft_model_code, engine_model_code, registrant_name, registrant_city, registrant_state
  FROM 'https://openairdocs.org/data/latest/faa_aircraft_registration.parquet'
  WHERE aircraft_model_code IN (SELECT aircraft_model_code FROM 'https://openairdocs.org/data/latest/faa_aircraft_model_directive.parquet' WHERE ad_id = 'FAA:2007-04-19-R1')
    OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:2007-04-19-R1')
  ORDER BY n_number"

Prints the whole list as CSV. It reads the release’s Parquet files over HTTPS, so there’s nothing to download first. Install DuckDB to run it.

N444AFContinental Aero Associates Inc · Grosse Pointe Park, MIBuilt 1974 · S/N D-9590N444AJAj2 Air LLC · Arroyo Grande, CABuilt 2015 · S/N 13919N444AWHangar 22 LLC · Wilmington, DEBuilt 1995 · S/N 373-95N444BDAddington James T · Denton, TXBuilt 1960 · S/N 94629N444BJLelouis Michael P · Sacramento, CABuilt 1962 · S/N D-7023N444BLTri Air LLC · Monette, ARBuilt 1966 · S/N 99N444BRNational Aviation Academy Of Mississippi Inc · Clearwater, FLS/N 310H0062N444BSSiemens Christopher L · Seminole, TXBuilt 1978 · S/N 21062823N444BUHelifun Expeditions LLC · Kalispell, MTBuilt 2023 · S/N 14633N444BWAmigo Helicopter Services LLC · Falfurrias, TXBuilt 2006 · S/N 11254N444BZWilliams Allen G Jr · Fort Worth, TXBuilt 1974 · S/N 414-0490N444CCVon Almen James Martin · Lewisburg, TNBuilt 1979 · S/N CE-845N444CHSouthport Aviation Inc · Hephzibah, GAS/N TC-1736N444CJAms Company Inc · Cleburne, TXBuilt 2024 · S/N 14712N444CLK G L Aviation Inc · Villisca, IABuilt 1975 · S/N 21060910N444CPMercure Ryan K · Eads, TNBuilt 1963 · S/N 30-230N444CRUtah State University · Logan, UTBuilt 2012 · S/N 4578N444CSStover Charles S · Ft Lupton, COBuilt 2001 · S/N 3994N444CTLeseviciute Audrone · Stamford, CTBuilt 2004 · S/N 3232032N444DBBalint Jozef · Fort Worth, TXBuilt 1978 · S/N 7-0106N444DDHardin Donald D Trustee · Kirkwood, MOBuilt 1983 · S/N 1423N444DGSwanson Douglas A · Marana, AZS/N D-9882N444DJSims George W III · Eclectic, ALBuilt 1970 · S/N 700075N444DMGosnell Josh W · Richards, TXBuilt 1974 · S/N 414-0522N444DPStratospheric Ventures LLC · Saint Petersburg, FLBuilt 1974 · S/N 28R-7435167N444DTBagdasarian Walter DBA · El Cajon, CAS/N 4608008N444DVSky High Helicopters LLC · Camarillo, CABuilt 2006 · S/N 1662N444DWTriple 4 Dw LLC · Davie, FLBuilt 1972 · S/N D-9416N444EEVaughn Stewart C · West Jordan, UTBuilt 1974 · S/N 17263906N444FRegistration Pending · Auburn, CARegistration pendingBuilt 1977 · S/N 21061686N444FCCentric It Resources LLC · Loomis, CABuilt 1981 · S/N EA-257N444FDJohnson Heimana J · San Marcos, CABuilt 1994 · S/N 2082N444FEN444fe LLC · Stuart, FLBuilt 1979 · S/N ME-142N444FGFrancis Andrew J III · Spring, TXBuilt 1981 · S/N 28-8190283N444FRRainier Flight Service LLC · Renton, WABuilt 2015 · S/N 172S11577N444FWKuntz Clark · Tallahassee, FLBuilt 1977 · S/N 32R-7780425N444GCCampbell Gregory A · Davis, ILBuilt 2005 · S/N ES-176N444GENeverland LLC · Emerson, IABuilt 1978 · S/N 18266675N444HGHigher Ground Helicopters Of Cincinnati LLC · Miamisburg, OHBuilt 2006 · S/N 11453N444HHAircraft Management Group Intl Corp Trustee · Wilmington, DEBuilt 2010 · S/N 12692N444HKChurch David H · Albuquerque, NMBuilt 2003 · S/N 29-0312N444HSCampi Curtis A · Boulder City, NVS/N T-1978N444HTTaktos Ltd · Corvallis, ORBuilt 1973 · S/N 310Q0739N444HUDorsey Sage · Bend, ORBuilt 1998 · S/N 1396N444HYHutton Mark · Denison, TXBuilt 2006 · S/N 2353N444JGGrimmonpre Mark D · Fort Walton Beach, FLBuilt 1968 · S/N 17257013N444JLColby Christopher F · Hampton, VABuilt 1966 · S/N 28-22224N444JMPeck Joseph A · Pound Ridge, NYBuilt 1976 · S/N 340A0280N444JTFilho Aniz Rasslan · Payson, AZBuilt 2001 · S/N 2973N444JYSchwarzenberg Johannes · Helena, MTBuilt 2007 · S/N 11600
Back to AD 2007-04-19 R1