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.

N4944PReed John Richard · Charleston, ILBuilt 1964 · S/N 18255703 N4944SEmbry Riddle Aeronautical University · Prescott, AZBuilt 1980 · S/N R18201483 N4945AIverson Randy · Winnemucca, NVBuilt 1956 · S/N 32342 N4947AGleiter David W · Overland Park, KSBuilt 1956 · S/N 32344 N4947DEnstrom Thomas · New Berlin, NYBuilt 1958 · S/N 51047 N4947SZams Aviation LLC · Raleigh, NCBuilt 1980 · S/N R18201486 N4948DSobrado Victor M · Norman, OKBuilt 1958 · S/N 51048 N4948URegistered aircraftBuilt 1965 · S/N 21058648 N4949NCompass Rose Aviation · Derby, KSBuilt 1979 · S/N 18267474 N494PCChristensen Darrel W Jr · Soldotna, AKS/N U20603156 N4950HVaivadas Brian S · Bonney Lake, WABuilt 1981 · S/N 18267856 N4950RCivil Air Patrol Inc Natl Hdqtrs · Maxwell Afb, ALBuilt 1984 · S/N U20606810 N4950UAerotech Mapping Inc · Las Vegas, NVBuilt 1979 · S/N U20605174 N4950ZRiverside Tractor Inc · Friendswood, TXBuilt 1980 · S/N U20606055 N4951FAerial Services Inc · Cedar Falls, IAS/N U206-0651 N4951NCactus Av8rs LLC · Gilbert, AZBuilt 1979 · S/N 18267476 N4951YH & B Aeronautics LLC · Miamisburg, OHBuilt 1980 · S/N 21064057 N4953AOlson Andrew P · Garfield, WABuilt 1956 · S/N 32350 N4954DTracy Scott J · Santa Barbara, CAFirst renewal noticeBuilt 1958 · S/N 51054 N4955YLancaster Bryant F Jr · Troutman, NCBuilt 1980 · S/N 21064058 N4956NCosta Luiz A · Fort Myers, FLBuilt 1980 · S/N 18267480 N4957DCummings Roy E · Fort Scott, KSBuilt 1958 · S/N 51057 N4957FBravo Hotel LLC · Lewes, DEBuilt 1966 · S/N U206-0657 N4957NRegistered aircraftS/N 18267481 N4957ZGuinasso Kimberly Marsh · Reno, NVS/N U20606059 N4958DHarmon Jon E · Turner, MTBuilt 1958 · S/N 51058 N4959CDoll House Properties Inc · Chesapeake, VABuilt 1979 · S/N 21063689 N4959DEdwards Stephen L Trustee · Wasilla, AKBuilt 1959 · S/N 50511 N495EMAround The Patch LLC · Memphis, TNBuilt 1974 · S/N 18263485 N495KKatmai Air LLC · Anchorage, AKBuilt 1974 · S/N U20602549 N495MCC182t LLC · Chattanooga, TNBuilt 2007 · S/N 18281895 N495WWNational Aircraft Leasing Corp · Greenville, DEBuilt 2009 · S/N 18282170 N4960DRasmussen Scott M · Santa Cruz, CABuilt 1958 · S/N 51060 N4960JPonderosa Airtankers LLC · Safford, AZBuilt 1981 · S/N T18803791T N4960UHopkins Breck G · North Little Rock, ARBuilt 1965 · S/N 21058660 N4961AGunson Robert S · Star, IDBuilt 1956 · S/N 32358 N4962DMcdonald Richard Reid · Rock Island, WAS/N 51062 N4962FEvans Dick G Trustee · Riverside, CABuilt 1966 · S/N U206-0662 N4963NHarrison Earl S · Clarksville, TNBuilt 1979 · S/N 18267485 N4963UAllen Shanda · Aynor, SCBuilt 1965 · S/N 21058663 N4964AThree Sisters Capital LLC · Visalia, CABuilt 1956 · S/N 32361 N4964DGrizzly Air Service Inc · Paris, TXBuilt 1958 · S/N 51064 N4964FTeam Builders Inc · Carson City, NVBuilt 1966 · S/N U206-0664 N4965NDowner Michael · Scottsdale, AZBuilt 1979 · S/N 18267487 N4966E4966e LLC · Kalispell, MTBuilt 1956 · S/N 33000 N4967DSchmieding Michael A · Salem, ORBuilt 1958 · S/N 51067 N4967FMile Hi Skydivers Inc · Longmont, COBuilt 1966 · S/N U206-0667 N4968AD&B Aircraft Leasing LLC · Anchorage, AKBuilt 1956 · S/N 32365 N4968DNelson Scott D · Blackfoot, IDBuilt 1958 · S/N 51068 N4968NConfarotta Todd A · Mount Pleasant, SCBuilt 1979 · S/N 18267489

Back to AD 84-10-01 R1