Skip to content

Registered aircraft · 20,687

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:90-06-03-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:90-06-03-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:90-06-03-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:90-06-03-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:90-06-03-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:90-06-03-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.

N7612GSwartwood Thomas C · Everson, WABuilt 1970 · S/N 17259312 N7612TBabcock Douglas O · Chesterton, INBuilt 1960 · S/N 47212 N7615GWashington Samuel C · Washington, DCS/N 17259315 N7615TN Maple LLC · Kalispell, MTS/N 47215 N7615XEagle Flight Inc. · Fremont, NEBuilt 1960 · S/N 17248115 N76172Rjd Flight LLC · North Canton, OHBuilt 1975 · S/N 17265906 N7619GMercer Aviators Inc · Princeton, WVBuilt 1970 · S/N 17259319 N7619XWeitzel Claus P · Newington, GABuilt 1960 · S/N 17248119 N761LAIowa Lakes Community College · Estherville, IABuilt 1976 · S/N 172-67476 N7620GDc Aero LLC · Ramona, CABuilt 1970 · S/N 17259320 N7620XRegistered aircraftBuilt 1960 · S/N 17248120 N7621GCrewdawg Aviation LLC · Concord, NCBuilt 1970 · S/N 17259321 N7621TScheetz Wayne E · Center Point, IABuilt 1960 · S/N 47221 N7622GBell Sky Pilots Inc · Reedley, CABuilt 1970 · S/N 17259322 N7622TFuhrman Chad L · Manchester, TNBuilt 1960 · S/N 47222 N7622XReale R Robert · Marblemount, WABuilt 1961 · S/N 17248122 N7623GPlane Sane Aero LLC · Cary, NCBuilt 1970 · S/N 17259323 N7623TMooney Micheal E · Auburn, INBuilt 1960 · S/N 47223 N7623XDorman David L · Garfield, MNBuilt 1960 · S/N 17248123 N7624GAeroflight Flying Club Inc · Jackson, TNBuilt 1970 · S/N 17259324 N7624TAir & Opportunity Aviation LLC · Yorktown, VABuilt 1960 · S/N 47224 N7626TKoch Suzanne Elizabeth · Battle Ground, WABuilt 1960 · S/N 47226 N7627XFindley Michael A · Moreland, GAS/N 17248127 N7628XZintz Michael S · Centerville, IABuilt 1960 · S/N 17248128 N7629GDodd Dennis R · Collinsville, OKBuilt 1970 · S/N 17259329 N7629TBork Joseph L · Masier, ORS/N 47229 N7629XNeu Aviation LLC · Benton, LABuilt 1960 · S/N 17248129 N762CPCivil Air Patrol · Maxwell Afb, ALBuilt 2015 · S/N 172S11576 N7631GChickadee Aviation LLC · Rangeley, MEBuilt 1970 · S/N 17259331 N7631XCiccosanti John P · Kingston, NYBuilt 1960 · S/N 17248131 N7632XTrompeter Mark S · Intl Falls, MNBuilt 1960 · S/N 17248132 N7633XHillis Robert Duane · Utopia, TXBuilt 1960 · S/N 17248133 N7636GDurham Ranches Inc · Gillette, WYBuilt 1970 · S/N 17259336 N7636TN7636t LLC · Farmdale, OHBuilt 1960 · S/N 47236 N7637GEverett Flying Service Inc · Holly Grove, ARBuilt 1970 · S/N 17259337 N7637XReddy Investments LLC · Contoocook, NHS/N 17248137 N7638GMoseley Michael S · Chelsea, ALBuilt 1970 · S/N 17259338 N7638TEaglet Flight Operations Lp · Fort Worth, TXBuilt 1960 · S/N 47238 N7638XBreaux Matthew J · Grosse Tete, LAS/N 17248138 N7639TCaldwell Perrin L · Batesville, MSBuilt 1960 · S/N 47239 N763CPCivil Air Patrol · Maxwell Afb, ALBuilt 2015 · S/N 172S11578 N763SPSix Ten Ventures LLC · Grand Prairie, TXBuilt 2001 · S/N 172S8696 N7640GCreative Strategies Inc · Proctorville, OHBuilt 1970 · S/N 17259340 N7640TAloway Shaquetta S · Cleveland, OHS/N 47240 N7640XNotre Amour LLC · Cypress, TXBuilt 1960 · S/N 17248140 N7641XEngelhardt David J · Williamsburg, OHBuilt 1960 · S/N 17248141 N7642GAir Petunia · Claremont, CABuilt 1970 · S/N 17259342 N7642TLuthi Mark P · Rome, GABuilt 1960 · S/N 47242 N7642XGrey Eagle Aviation LLC · Walker, MNBuilt 1960 · S/N 17248142 N7643GTriad Aviation Academy LLC · Greensboro, NCBuilt 1970 · S/N 17259343

Back to AD 90-06-03 R1