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.

N5198DHaw LLC · Wilmington, DEBuilt 1958 · S/N 51298 N5198JMichigan Dept Of Natural Resources · Roscommon, MIBuilt 2009 · S/N 18282147 N5198QValiair Lc Trustee · Casper, WYBuilt 2010 · S/N 18282210 N5198TBlack Dog Aviation LLC · Troy, MIBuilt 2002 · S/N 20608178 N5198UFerguson Kenneth R · Tehachapi, CABuilt 1964 · S/N 206-0198 N5198VMaddock Jay B · Sugar Grove, ILS/N 21060859 N5199ESnowden Andrea K · Anchorage, AKBuilt 1959 · S/N 50499 N519AMRegistration Pending · Manheim, PARegistration pendingBuilt 2023 · S/N 18283225 N51AKSchroth Charles D DBA · Gustavus, AKS/N U20603785 N51BWMcclymond Bruce W · Breckenridge, TXBuilt 1981 · S/N 21064602 N51CHEcho Acquisitions LLC · Dover, DES/N 18280112 N51CMCorley W Michael · Mc Minnville, TNBuilt 1972 · S/N 21059628 N51CVMarotta Daniel C · Tijeras, NMBuilt 1980 · S/N 18053160 N51ESBurton Donald O · Mooresville, NCBuilt 1955 · S/N 31839 N51HFSan Mateo County Sheriff'S Office · Redwood City, CABuilt 2012 · S/N 20608347 N51PHAasen Christopher N · Corvallis, ORBuilt 1964 · S/N 18051478 N51RMiozzi Thomas E · Jamestown, RIBuilt 1965 · S/N 18051631 N51SARedtail Partners LLC · Moab, UTBuilt 1981 · S/N 20700699 N51SPDepartment Of Public Safety · Dover, DEBuilt 1980 · S/N 18267563 N51YTRupp Steven S · Cameron Park, CABuilt 1978 · S/N 18266686 N52004Jones Steve M · Anchorage, AKBuilt 1974 · S/N 18052437 N52009Sale Reported · Palmer, AKSale reportedBuilt 1974 · S/N 18052438 N5200ABarr Air Patrol LLC · Mesquite, TXBuilt 2002 · S/N 18281128 N5200EViaene Tajae L · Fargo, NDFirst renewal noticeBuilt 1959 · S/N 50500 N5200QBas Part Sales LLC · Greeley, COBuilt 1969 · S/N 21059130 N5200XRwr Air Inc · Tok, AKBuilt 1980 · S/N U20605591 N52010Bentley John R · Bend, ORS/N 18052439 N52016Lil' Dawg Aviation Inc · Oxford, MSBuilt 1974 · S/N 18052442 N5201ADan Howard Aircraft Sales LLC · Tulsa, OKBuilt 1979 · S/N 21063305 N52026Moore Enterprises Leasing Inc · Indianapolis, INS/N 18052448 N5202NNorthern Aviation LLC · Palmer, AKBuilt 1980 · S/N 18267568 N52032Briner John T · Celina, TXBuilt 1974 · S/N 18052452 N52035Chancellor J W · Brooksville, MSBuilt 1974 · S/N 18052454 N5203AGv Air Inc · Medford, ORBuilt 1979 · S/N 21063306 N5203NNoam Eli · New York, NYBuilt 1980 · S/N 18267569 N5203UHusted Robert P · Byers, COBuilt 1964 · S/N 206-0203 N5203XMike & Critter LLC · Mccall, IDBuilt 1980 · S/N U20605592 N5204ECivil Air Patrol Inc · Maxwell Afb, ALS/N 18268299 N52051Cutsforth Gary L · Palmer, AKBuilt 1974 · S/N 18052465 N52055Schley James R · Palmer, AKBuilt 1974 · S/N 18052467 N5205EGates Stephanie E · Sutton, AKBuilt 1959 · S/N 50505 N52063Hattenburg Bryce R · Eagle River, AKBuilt 1974 · S/N 18052472 N52065Land Air Enterprises Inc · Boynton Beach, FLBuilt 1974 · S/N 18052474 N52067Rexine Jeffrey A · Chandler, AZBuilt 1974 · S/N 18052476 N5206UMudminers LLC · Wasilla, AKBuilt 1964 · S/N 206-0206 N52072Wicked Wings Aviation LLC · Dover, DEBuilt 2002 · S/N 18281137 N52083Gorn Anthony S · Nome, AKBuilt 1974 · S/N 18052488 N52084Lutz Adam R · Kodiak, AKBuilt 1974 · S/N 18052489 N5208EHelmericks Mark H · Anchorage, AKS/N 50508 N5208S5fs Aviation LLC · Lewes, DEBuilt 2002 · S/N 18281138

Back to AD 84-10-01 R1