Skip to content

Registered aircraft · 2,375

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:82-06-11-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:82-06-11-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:82-06-11-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:82-06-11-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:82-06-11-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:82-06-11-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.

N5249TTri-Angle Aviation LLC · Henderson, KYBuilt 1972 · S/N 28R-7235204 N524PAm Utilities & Construction LLC · Palmhurst, TXBuilt 1969 · S/N 28R-35263 N5250TMedlaw Aviation LLC · Temple, TXS/N 28R-7235206 N525VBLincoln Robert D · Bedminster, NJFirst renewal noticeBuilt 1978 · S/N 28R-7837287 N5262TSmith Gregory W · Laurel, MDBuilt 1972 · S/N 28R-7235210 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 N52KCTlc Developments LLC · Sheridan, WYBuilt 1980 · S/N 28R-8031169 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 N533KGautier Timothy L · Merritt Island, FLBuilt 1977 · S/N 28R-7703201 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 N535GWBruno Anthony · Omaha, NEBuilt 1977 · S/N 28R-7703269 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 N540AGAircraft Guaranty Corp Trustee · Oklahoma City, OKBuilt 1984 · S/N 28R8431025 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

Back to AD 82-06-11 R1