Skip to content

Registered aircraft · 40,394

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:79-10-03-R2') OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:79-10-03-R2') 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:79-10-03-R2')
    OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:79-10-03-R2')
  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:79-10-03-R2')
  OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:79-10-03-R2')
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.

N8846NDegener William L · Leonard, TXBuilt 1969 · S/N 28-25697 N88473A C E Aviation Inc · Ashton, IDBuilt 1974 · S/N 306-75 N88477Holland William T III · Midway, ARBuilt 1974 · S/N 136-75 N8847CBlumenberg Donald D · Fulton, SDBuilt 1953 · S/N 22-1459 N8847FNeitzer Robert W · Milwaukee, WIBuilt 1976 · S/N 28-7725126 N8847JFlw LLC · Sandpoint, IDS/N 28-2805 N8847NMcdougal Thomas K · Woodward, OKBuilt 1969 · S/N 28-25699 N8848JMegaw George C · Fort Lauderdale, FLBuilt 1965 · S/N 28-2806 N8848NPro Tech Aviation LLC · Corona, CABuilt 1969 · S/N 28-25700 N8849JBailey Aviation Company LLC · Little Rock, ARBuilt 1965 · S/N 28-2807 N8849NCafran Lloyd V · Youngsville, NCBuilt 1969 · S/N 28-25701 N884CAColeman Aero Club · Apo AeBuilt 1978 · S/N 17271876 N884DCTanner Greg L · Bend, ORBuilt 1961 · S/N 24-2434 N884JSCrane John R · Niceville, FLBuilt 1977 · S/N 340-77 N884PSSpainhower Paul Allex · Taylorsville, UTS/N 2318 N884SADamico Frank J · Pittsburgh, PABuilt 2003 · S/N 0037 N8850NGregs Airplane Rental LLC · Eloy, AZBuilt 1969 · S/N 28-25702 N8851JMoore Jeffrey A · Lawrenceburg, TNBuilt 1965 · S/N 28-2815 N8851NBloodworth Nathan B · Hendersonville, TNS/N 28-25703 N8853DSlaughter Don Wayne · Farmville, NCBuilt 1958 · S/N 22-6024 N8853JN8853j LLC · Oak Park, ILBuilt 1965 · S/N 28-2817 N8854CMid Continent Aircraft Corp · Hayti, MOBuilt 1953 · S/N 18-2900 N8854DKidd Clifford L Jr · Monahans, TXBuilt 1958 · S/N 22-6025 N8854LPfs Air Inc · Yellville, ARBuilt 1974 · S/N AA5-0654 N8855NIndy Distributors Inc · Noblesville, INBuilt 1969 · S/N 28-25709 N8856CBritton Mark W · Wasilla, AKBuilt 1953 · S/N 18-2913 N8856JFifty Six Juliet LLC · West Lafayette, INS/N 28-2820 N8856LRuales Edison R · Miami, FLFirst renewal noticeBuilt 1974 · S/N AA5-0656 N8856NGrant Shane J · Cape Coral, FLBuilt 1969 · S/N 28-25711 N8857Aviation Management Systems LLC · Fallbrook, CABuilt 1973 · S/N 254-73 N8857DHollan William E Jr · Winston Salem, NCBuilt 1958 · S/N 22-6028 N8857JNguyen Tu K · Costa Mesa, CABuilt 1965 · S/N 28-2822 N8857MDunn Brady · Gilmer, TXS/N M-597 N8857NWolf Terry T · Lake Katrine, NYBuilt 1969 · S/N 28-25712 N8858JBirdie N88 LLC · Conifer, COBuilt 1965 · S/N 28-2928 N8859DBbc Group LLC · Sanford, NCBuilt 1958 · S/N 22-6030 N8859NThrash Enterprises LLC · Clarksville, TNBuilt 1969 · S/N 28-5340 N885SABlevins Edgar R · Zachary, LABuilt 2001 · S/N 0014 N8860DCooley Tony A · Dallas, ORBuilt 1958 · S/N 22-6032 N8860JBjg LLC · Langdon, NHBuilt 1965 · S/N 28-2826 N8861FMurtaza Syed S · Minneapolis, MNBuilt 1976 · S/N 28-7715292 N8861NMcdonald Timothy A · Rush City, MNBuilt 1969 · S/N 28-25410 N8862FAircraft Guaranty Corp Trustee · Oklahoma City, OKBuilt 1976 · S/N 28-7715293 N8862LTisdale Matthew · Alameda, CABuilt 1974 · S/N AA1B-0362 N8862NHatley Wayne S · Hermitage, TNBuilt 1969 · S/N 28-25717 N8862YState Of Montana · Helena, MTBuilt 1973 · S/N 18-7409026 N8863DSanders Darrel T · Camp Douglas, WIBuilt 1958 · S/N 22-6037 N8864DMarsteller Paul A · Tallulah Falls, GABuilt 1958 · S/N 22-6038 N8866NYu Hermon Lemuel C · Mays Landing, NJBuilt 1969 · S/N 28-26251 N8866YCarson Ryan P · Albuquerque, NMBuilt 1971 · S/N 28-7125339

Back to AD 79-10-03 R2