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.

N9718GCain Curtis S · Reno, NVBuilt 1971 · S/N 18052218 N9718XLooney Jeffrey J · New Boston, TXBuilt 1962 · S/N 21058018 N97190Hickman Donald E II Trustee · Medford, ORBuilt 1979 · S/N 18267009 N97192Atlantis Construction Inc · Friday Harbor, WABuilt 1979 · S/N 18267010 N97196N2893e LLC · Reno, NVBuilt 1979 · S/N 18267011 N97199Perry Martin Dale · Denton, TXBuilt 1979 · S/N 18267012 N971BBColon Hector L · Gainesville, GABuilt 1974 · S/N 18263473 N971CPCivil Air Patrol · Maxwell Afb, ALBuilt 2007 · S/N 18281971 N971RWSutherland James P · Wausau, WIS/N 18267004 N971SPIllinois State Police · Springfield, ILBuilt 1999 · S/N 18280653 N97200Aragon Cecilia · Sequim, WABuilt 1979 · S/N 18267013 N9720GZarones Erik R · Paris, TXBuilt 1971 · S/N 18052220 N9720MIliamna Air Taxi Inc · Iliamna, AKBuilt 1981 · S/N 20700720 N9720NNash Clay S · Irving, TXS/N 57036 N9720RPca Tail One LLC · Wilmington, DEBuilt 1968 · S/N 18258836 N9720XHogue Richard L · Dos Palos, CABuilt 1962 · S/N 21058020 N97211G & G 24 LLC · Clancy, MTS/N 18267015 N97218Mcgraw Thomas M II · Prescott, AZS/N 18267018 N9721GFahrenbruck George · Anchorage, AKBuilt 1971 · S/N 18052221 N9721ZRwr Inc · Wasilla, AKBuilt 1982 · S/N U20606625 N97220Summit Crest Capital LLC · Palos Heights, ILS/N 18267020 N97221Smith Brian A · Big Pine Key, FLBuilt 1979 · S/N 18267021 N9722XEddy David A · Gilroy, CABuilt 1962 · S/N 21058022 N97231Pacific Rim Aviation LLC · Corvallis, ORBuilt 1979 · S/N 18267025 N97233Frahm Lon R · Colby, KSBuilt 1979 · S/N 18267026 N97237Headley Mark E · Akron, OHBuilt 1979 · S/N 18267028 N97238Sanctuary Wings LLC · Norfolk, VAS/N 18267029 N9723XThornton James P · Amesbury, MABuilt 1962 · S/N 21058023 N97240N97240 LLC · Amherst, MABuilt 1979 · S/N 18267030 N97246Duggins Robert W · Van Nuys, CAS/N 18267034 N97257Moser Keith W · Huntington, INBuilt 1979 · S/N 18267037 N9725GMathis Isaac Thomas · Fletcher, NCBuilt 1971 · S/N 18052225 N9725RLongitude 150 LLC · Anchorage, AKBuilt 1986 · S/N U20606950 N9725VAnderson Aerial Spraying Service Inc · Canby, MNBuilt 1966 · S/N 188-0175 N9725XNewling Galen J · Bremerton, WABuilt 1962 · S/N 21058025 N9726GIrc Holdings Ltd · Allentown, PABuilt 1971 · S/N 18052226 N9727GInternational Air Services Inc Trustee · Carson City, NVBuilt 1971 · S/N 18052227 N97281Wackerli Steve B · Idaho Falls, IDFirst renewal noticeBuilt 1979 · S/N 18267041 N97282Jav Air Services LLC · Anchorage, AKBuilt 1979 · S/N 18267042 N97288Bolle Aviation LLC · Clare, MIBuilt 1979 · S/N 18267044 N9728BLowery Janell D · Anchorage, AKBuilt 1957 · S/N 50026 N9728MGrant Aviation Inc · Anchorage, AKBuilt 1981 · S/N 20700721 N97295J-Air LLC · Guthrie, OKBuilt 1979 · S/N 18267047 N97298Roberts And Connell Llp · San Luis Obispo, CABuilt 1979 · S/N 18267048 N9729BAnderson Benjamin T · Havre De Grace, MDBuilt 1957 · S/N 50027 N9729GBurch Gerald T · Lake Charles, LABuilt 1971 · S/N 18052229 N972GJPolk County Sheriffs Office · Winter Haven, FLBuilt 2006 · S/N 18281843 N972LLTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTBuilt 1967 · S/N U2060705 N97300Jaeger Kurt · Bermuda Dunes, CABuilt 1979 · S/N 18267050 N97309Afana Lawrence L Jr · Phoenix, AZS/N 18267054

Back to AD 84-10-01 R1