Skip to content

Registered aircraft · 20,481

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:84-10-01-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:84-10-01-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:84-10-01-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:84-10-01-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:84-10-01-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:84-10-01-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.

N8916GSorenson Robert H · Forsyth, MTBuilt 1970 · S/N 18260456 N8917XCleveland William B III · Canal Fulton, OHBuilt 1961 · S/N 18253317 N8918TAirtime LLC · Wilmington, DEBuilt 1960 · S/N 52818 N8918XRtillery Services LLC · Holdrege, NEBuilt 1961 · S/N 18253318 N8919TUllmann Wilmer R · Fairview, TXS/N 52819 N891CPCivil Air Patrol · Maxwell Afb, ALBuilt 2015 · S/N 18282411 N891SPSkydive Pennsylvania · Mercer, PABuilt 1957 · S/N 34272 N8921TRoberts Marty · Mount Hermon, LABuilt 1960 · S/N 52821 N89225Lucky Dog Aviation LLC · Victoria, TXBuilt 2022 · S/N 18283169 N8924XPrevo Jerry L · Anchorage, AKBuilt 1961 · S/N 18253324 N8925XMuetterties Eric Joseph · Dublin, CABuilt 1960 · S/N 18253325 N8926TBowlin George E · Roanoke, INBuilt 1960 · S/N 52826 N8926XNelson Bobby E · Naples, FLS/N 18253326 N8927TRockfish Ventures LLC · Wilmington, NCBuilt 1960 · S/N 52827 N8927XSkydive Mid America LLC · Macon, MOS/N 18253327 N8929XDivan Jeremy · Castle Rock, COBuilt 1961 · S/N 18253329 N892BVGd Aviation Inc · Belleair, FLBuilt 2004 · S/N 18281329 N8931GJordan Robert Nelson · Oakdale, LABuilt 1970 · S/N 18260471 N8931XBelding Kirk A · Grass Valley, CAS/N 18253331 N8933XSnyder Mark · Norwood, COBuilt 1961 · S/N 18253333 N8934GCallender Andrew T · Howard City, MIS/N 18260474 N8935GHagouel Yehouda · Reseda, CABuilt 1970 · S/N 18260475 N8935MGoldberg Alan N · Point Clear, ALBuilt 1972 · S/N 21059635 N8937GRussin William A · Gurnee, ILS/N 18260477 N8938GTenore William H · Lyons, COBuilt 1971 · S/N 18260478 N8939GIms Aviation LLC · Kawkawlin, MIBuilt 1970 · S/N 18260479 N8939TFeeny Daniel J · Townsend, MTBuilt 1960 · S/N 52839 N893CPCivil Air Patrol · Maxwell Afb, ALBuilt 2006 · S/N 18281863 N8940GCapps Christopher N · Austin, TXBuilt 1970 · S/N 18260480 N8940XKish John · Fort Mohave, AZBuilt 1961 · S/N 18253340 N8941TGeco Inc · Wilmington, DEBuilt 1960 · S/N 52841 N8941XParrish Perry W · Columbia, KYS/N 18253341 N8942GSale Reported · Stevensville, MTSale reported, canceledBuilt 1970 · S/N 18260482 N8942TMonger Curtis V · Bend, ORS/N 52842 N8942XBlb Group LLC · Lake Havasu City, AZBuilt 1961 · S/N 18253342 N8943GTruyaert Ivan R Jr · New Carlisle, INBuilt 1970 · S/N 18260483 N8944GSagra Nw LLC · Ronan, MTBuilt 1970 · S/N 18260484 N8945TLumpkin Ed · Rosie, ARS/N 52845 N8945XHarty Arthur · Acampo, CABuilt 1961 · S/N 18253345 N8946XKennedy Dennis R Trustee · Westlake Village, CABuilt 1961 · S/N 18253346 N8947XN8947x LLC · Middletown, DEBuilt 1961 · S/N 18253347 N8948GWilbur-Ellis Co · Salinas, CABuilt 1970 · S/N 18260488 N8948XRhodes Steven D · Anchorage, AKBuilt 1961 · S/N 18253348 N8949GChuckanut Flying Club Inc · Bellingham, WABuilt 1970 · S/N 18260489 N894AHAerospace Asset Holdings LLC · Wilmington, DEBuilt 1977 · S/N U20604061 N894CPCivil Air Patrol · Maxwell Afb, ALBuilt 2006 · S/N 18281864 N8950TGribi Daniel M · Miranda, CAS/N 52850 N8950XAnderson Craig M · Barron, WIBuilt 1961 · S/N 18253350 N8951GThrash Helen · Pelahatchie, MSS/N 18260491 N8952TNorthwest Exteriors Inc · Rancho Cordova, CABuilt 1960 · S/N 52852

Back to AD 84-10-01 R1