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.

N79450Smith Jeff C · Cincinnati, OHBuilt 1969 · S/N 17258099 N79453Zimmer James E · Corning, CABuilt 1969 · S/N 17258101 N79454Gavranovic Willie · Wharton, TXBuilt 1969 · S/N 17258102 N7945GWinger Matthew · Vail, AZS/N 17259645 N79468Whitmire Alan K · Canyon Lake, TXS/N 17258113 N7946BBrock Raymond Richard · Crescent, IAS/N 29746 N7946GRegistration Pending · Beach City, TXRegistration pendingBuilt 1970 · S/N 17259646 N7946UUpper Aircraft International LLC · Titusville, FLBuilt 1964 · S/N 17251946 N79472Frey Michael L III · Waco, TXBuilt 1969 · S/N 17258115 N79473Tnw Aviation LLC · Clinton, ARS/N 17258116 N79475Registered aircraftBuilt 1969 · S/N 17258118 N79477Shipley David L · Yates City, ILBuilt 1969 · S/N 17258120 N79478Fusano Lisa A · La Crescenta, CAS/N 17258121 N79479Larue Mark C · Leander, TXBuilt 1969 · S/N 17258122 N7947BJames Bobby F · Bloomfield, INBuilt 1957 · S/N 29747 N7947GStearman Field Aircraft Repair LLC · Benton, KSBuilt 1970 · S/N 17259647 N79482Matacotta Ernest A · Marietta, GABuilt 1969 · S/N 17258123 N79488Nevels Steven D · Merritt Island, FLBuilt 1969 · S/N 17258126 N79489Maisonet Gonzalez Hector W · Ocala, FLBuilt 1969 · S/N 17258127 N7948BGruber Barbara L · Centreville, VABuilt 1957 · S/N 29748 N79493Bounds Trucking LLC · Faison, NCS/N 17258130 N79498Gord James F · Sandwich, ILBuilt 1969 · S/N 17258132 N79499Johnson Benjamin M · Monroe, WIBuilt 1969 · S/N 17258133 N7949BHeffron Jacob L · Little Falls, MNS/N 29749 N794CTCarolina Custom Farm Equipment LLC · Wilson, NCBuilt 1965 · S/N 17252598 N794FAAb Prop Plane II LLC · Metairie, LABuilt 2024 · S/N 172S13174 N79501Skyhawk Flying Club Inc · Omaha, NEBuilt 1969 · S/N 17258134 N79506Allen Michelle E · Sebastopol, CABuilt 1969 · S/N 17258138 N7950BBobka Christian · Apple Valley, MNBuilt 1957 · S/N 29750 N7950GRotormate LLC · Royse City, TXBuilt 1970 · S/N 17259650 N7950UBowden James E Jr · Eufaula, ALS/N 17251950 N79513Kalman Engineering Inc · Pekin, ILBuilt 1969 · S/N 17258142 N79514Galaxy Aviation LLC · Nantucket, MABuilt 1976 · S/N 17268134 N7951BRocky Creek Jbd Inc · Boca Grande, FLBuilt 1957 · S/N 29751 N7951URegistration Pending · New Smyrna Beach, FLRegistration pendingS/N 17251951 N79526Evink Bradley D · North Branch, MNBuilt 1969 · S/N 17258151 N79529Elliott Tina L · Tucson, AZBuilt 1969 · S/N 17258154 N7952BEmaw Properties LLC · Ketchum, OKBuilt 1957 · S/N 29752 N7952UTigger II Airways LLC · Towson, MDBuilt 1964 · S/N 17251952 N79531Newberry Tyler D · Clovis, CABuilt 1969 · S/N 17258155 N79533Eby William J · Sugar Grove, ILBuilt 1969 · S/N 17258156 N7953BSavener Eric D · Kingsland, TXBuilt 1957 · S/N 29753 N79540Funk Kathryn A · Rockledge, FLBuilt 1969 · S/N 17258160 N79543Registration Pending · Manns Harbor, NCRegistration pendingBuilt 1969 · S/N 17258163 N79546Diakonis Emmanuel W · Maumee, OHBuilt 1969 · S/N 17258165 N79549Triad Aviation Academy LLC · Greensboro, NCBuilt 1969 · S/N 17258168 N7954GNo Squawks LLC · Newcastle, CABuilt 1970 · S/N 17259654 N79554Williams Kenneth J · Wasilla, AKBuilt 1969 · S/N 17258171 N79558Silver Creek Aviation Services LLC · Snowflake, AZBuilt 1969 · S/N 17258173 N7955BCochrane Geoffrey G · Seville, OHBuilt 1957 · S/N 29755

Back to AD 90-06-03 R1