Skip to content

Registered aircraft · 1,753

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:81-11-02-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:81-11-02-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:81-11-02-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:81-11-02-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:81-11-02-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:81-11-02-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.

N5266SFogle Cooper · Mooresville, NCBuilt 1971 · S/N 28R-7135120 N5271TOracle Aviation LLC · Omaha, NEBuilt 1972 · S/N 28R-7235212 N5282TMehlberg Jerry L · Medford, WIBuilt 1972 · S/N 28R-7235215 N5283TN5283t LLC · Reno, NVBuilt 1972 · S/N 28R-7235216 N529KMSmtm Holdings Inc · Wilmington, DES/N 28R-7435196 N52CLDannebrog Air LLC · Grand Island, NEBuilt 1971 · S/N 28R-7135042 N5301TTanner Fred K · Tuscaloosa, ALBuilt 1972 · S/N 28R-7235222 N530MCMagic Carpet LLC · Wilmington, DEBuilt 1972 · S/N 28R-7235258 N530PUConrad Brian Michael · Pasadena, MDBuilt 1989 · S/N 2837038 N531AAAirsmart Aviation Academy LLC · Las Vegas, NVBuilt 1980 · S/N 28R-8018098 N531GSNance Timothy Hunter · Advance, NCBuilt 1977 · S/N 28R-7837019 N531PUChrastka Keith · South Elgin, ILBuilt 1989 · S/N 2837039 N5321UUniversity Of Illinois · Savoy, ILS/N 2844042 N5325UAlian Andrus · Port Jefferson, NYBuilt 2001 · S/N 2844044 N5326UUniversity Of Illinois · Savoy, ILS/N 2844046 N532RRRegistered aircraftBuilt 1977 · S/N 28R-7737037 N5338FParker Gary L · Metamora, MIBuilt 1976 · S/N 28R-7635452 N533PUEagle Flyers Vii LLC · Carmel, INS/N 2837001 N533RBValdez Eddie III · Keller, TXBuilt 1981 · S/N 28R-8218002 N5347FDeland Aviation LLC · Deland, FLBuilt 1976 · S/N 28R-7635453 N53509Waynes Aircraft Maintenance · Homestead, FLBuilt 2002 · S/N 2844071 N5352DN5352d LLC · Costa Mesa, CABuilt 2002 · S/N 2844079 N5353GG & M Aircraft Inc · Wheat Ridge, COS/N 2844078 N53558University Of Illinois · Savoy, ILBuilt 2002 · S/N 2844083 N53580Synergy Aircraft Sales LLC · Bloomington, ILBuilt 2002 · S/N 2844087 N535TWJohnson William · New Wilmington, PABuilt 1973 · S/N 28R-7335381 N5370FRegistered aircraftBuilt 1976 · S/N 28R-7635460 N5370TK.M. Biggs Inc · Lumberton, NCBuilt 1972 · S/N 28R-7235228 N5374TWeaver Stephen E · Enon, OHBuilt 1972 · S/N 28R-7235229 N5391UJohnson Keith Richard · Frostproof, FLBuilt 1979 · S/N 28R-7918033 N53995Wilshire & Catalina LLC · Austin, TXBuilt 1979 · S/N 28R-7918258 N5399TParke Jonathan · Durham, NCBuilt 1972 · S/N 28R-7235231 N540PULeo S Anton · Aliso Viejo, CABuilt 2003 · S/N 2844096 N541HFOpen Flight Plan LLC · Decatur, GABuilt 1973 · S/N 28R-7335335 N541PUEquipment Maintenance Specialists LLC · Auxvasse, MOBuilt 2003 · S/N 2844097 N542HFPars Avn Corp · Wilmington, DEBuilt 1974 · S/N 28R-7435310 N542PUNewbridge Unlimited LLC · Sunny Isles Beach, FLBuilt 2003 · S/N 2844099 N54391Still Water Security Co LLC · Meriden, CTBuilt 1973 · S/N 28R-7435094 N54398Lashback Communications LLC · Farwell, MIBuilt 1973 · S/N 28R-7435097 N543POracle Aviation LLC · Omaha, NEBuilt 1974 · S/N 28R-7435227 N543PUByc Trucking Services LLC DBA · Norco, CABuilt 2003 · S/N 2844100 N54412Flight Time Builders Inc · Memphis, TNBuilt 1973 · S/N 28R-7435098 N54414Panjab Aviation Inc · Las Vegas, NVS/N 28R-7435101 N5442TMckinney Christopher W · Queensbury, NYBuilt 1972 · S/N 28R-7235232 N54473Gomez Julian E · Palo Alto, CAFirst renewal noticeBuilt 1973 · S/N 28R-7435110 N54485Schrock Paul · Mooresville, NCBuilt 1973 · S/N 28R-7435112 N545WRCumulus Aviation Services LLC · Port Orange, FLBuilt 1972 · S/N 28R-7235119 N5472TAdvantage Aviation Inc · Palo Alto, CABuilt 1972 · S/N 28R-7235234 N547BWBland Gregory A · Florence, KYBuilt 1974 · S/N 28R-7435217 N5495THill Mark D · Magnolia, TXS/N 28R-7235236

Back to AD 81-11-02 R1