Skip to content

AD 2007-04-19 R1

Registered aircraft · 108,433

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

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

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.

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

Run it at the DuckDB prompt, or in any tool that reads Parquet over HTTPS. More ways to query the release are on Use the data.

N2012ATownsend Brooks P · Hattiesburg, MSBuilt 1978 · S/N MC-599 N2012EAirgo Inc · Centralia, ILBuilt 1978 · S/N 17271117 N2012FEpic Aviation Inc · Denison, TXBuilt 2025 · S/N 172S13452 N2012GMchugh Michael J Trustee · Hailey, IDBuilt 1958 · S/N 51312 N2012KMaine Instrument Flight · Augusta, MEBuilt 1978 · S/N MB-901 N2012LRegistration Pending · Dallas, TXRegistration pendingBuilt 1966 · S/N 345 N2012NAirhawks Flying Clup · Eastsound, WABuilt 1978 · S/N M-2068 N2012RPhysical Therapy And Sports Solutions LLC · Santa Fe, NMBuilt 1964 · S/N 18255212 N2012S9791m LLC · Tacoma, WAS/N 21060980 N2012WIron Compass LLC · Highland Park, MIBuilt 1965 · S/N D-7971 N2012YLake Robert P · Fruita, COBuilt 2006 · S/N 18281770 N20132J & L Aviation LLC · Malta, NYBuilt 1972 · S/N 17261035 N20133Creative Strategies Inc · Proctorville, OHBuilt 1972 · S/N 17261036 N20136Crate Inc · Humboldt, NEBuilt 1972 · S/N 17261038 N2013AMusketeer LLC · Fayette, ALBuilt 1978 · S/N MB-902 N2013NSimply Living LLC · Fort Myers, FLBuilt 1978 · S/N M-2070 N2013RZinsmeyer Charles D · Llano, TXBuilt 1964 · S/N 18255213 N2013WEpic Aviation Inc · Denison, TXBuilt 2025 · S/N 172S13451 N2013XEec Group LLC · Kalispell, MTBuilt 1965 · S/N 18256113 N2014Blue Skies Trading Company LLC · Toledo, OHS/N 18052338 N20141Bbrrjd Inc · Wilmington, DEBuilt 1972 · S/N 17261042 N20143Loomis Aviation LLC · Gahanna, OHBuilt 1972 · S/N 17261044 N20148Baron 1-4-8 LLC · Merrimack, NHS/N TC-2159 N2014COharra Robert J · Buckley, WABuilt 2003 · S/N 001 N2014EWanda Collins Professional Pilot Services LLC · Madisonville, TXBuilt 1978 · S/N 17271118 N2014GReich Gary J Trustee · Chippewa Falls, WIBuilt 1978 · S/N MC-606 N2014LGreenwood Daniel · Golconda, ILBuilt 1966 · S/N 347 N2014PAerial Sign North · Lakewood, NJBuilt 1956 · S/N 18-4602 N2014RDaedalus Wings Inc · Malvern, OHBuilt 1964 · S/N 18255214 N2014SGaige Gerald · Gassville, ARBuilt 2006 · S/N 18281772 N2014XTashjian Kirk G · Stanwood, WABuilt 1965 · S/N 18256114 N20154Jones 170a LLC · Bridgman, MIBuilt 1972 · S/N 17261051 N20155Wild Wingdom LLC · Greenville, SCBuilt 1972 · S/N 17261052 N20157Kelley Aircraft LLC · Weyers Cave, VABuilt 1972 · S/N 17261053 N20158Vbp Services LLC · Wainscott, NYBuilt 1972 · S/N 17261054 N20159Western Edge Aviation LLC · Dickinson, NDBuilt 1972 · S/N 17261055 N2015CMorgan Arrow LLC · Greeley, COBuilt 1978 · S/N E-1311 N2015RBennett Peter D · Birmingham, ALBuilt 1964 · S/N 18255215 N2015T2015t LLC · Omaha, NEBuilt 1978 · S/N CE-795 N2015VMangi Nitin · Hayward, CABuilt 1959 · S/N D-5760 N2015WKrosswind Aviation LLC · Cape Coral, FLBuilt 1965 · S/N D-7975 N2015XAircraft Trade Group LLC · Scandia, MNS/N 18256115 N20162Wateractive43 LLC · Auburn, CABuilt 1974 · S/N 310Q-1004 N20169R D T Aviation Inc · Williston, VTBuilt 1972 · S/N 17261062 N2016CRavey Guy W · Virginia Beach, VABuilt 1978 · S/N TC-2175 N2016DRbc Aero · Mooresville, NCBuilt 1966 · S/N D-8209 N2016FEpic Aviation Inc · Denison, TXBuilt 2025 · S/N 172S13450 N2016KAlp Paul · Falls Church, VABuilt 1978 · S/N TC-2163 N2016NOsfly LLC · Wilmington, DEBuilt 1978 · S/N E-1313 N2016PVladimir Ravich · Fort Montgomery, NYS/N 23-588

Back to AD 2007-04-19 R1