Skip to content

Registered aircraft · 40,396

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:79-10-03-R2') OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:79-10-03-R2') 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:79-10-03-R2')
    OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:79-10-03-R2')
  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:79-10-03-R2')
  OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:79-10-03-R2')
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.

N52217Mustang Sally Aviation LLC · Camden, SCBuilt 1980 · S/N 17274441 N52218Jej Leasing LLC · Bangor, MEBuilt 1980 · S/N 17274442 N52219Warren Flying Club Inc · Troy, MIBuilt 1980 · S/N 17274443 N5221EAir Capital Aviators Club · Wichita, KSBuilt 1978 · S/N 17271778 N5221LVeritable Solutions LLC · Bremerton, WABuilt 1967 · S/N 28-4514 N5221RDunaway Jeffrey W · Bremerton, WABuilt 1974 · S/N 17263435 N5221WGrady John M · Perham, MNBuilt 1961 · S/N 28-258 N52220Meyer Jeffrey K · Osceola, WIBuilt 1980 · S/N 17274444 N5222DRegistration Pending · Muncie, INRegistration pendingBuilt 1979 · S/N 17272456 N5222JFlywyo LLC · Kalispell, MTBuilt 1980 · S/N 17273738 N5222PGharazeddine Raja N · Kaplan, LABuilt 1958 · S/N 24-249 N5223RN5223r LLC · Opa Locka, FLBuilt 1974 · S/N 17263437 N5223TBarnard Kevin D · Columbia Station, OHBuilt 1972 · S/N 28-7225362 N5223WStover Jeffrey Wayne · Gastonia, NCBuilt 1961 · S/N 28-260 N5224KAri Ben Aviator Inc · Fort Pierce, FLBuilt 1980 · S/N 17274018 N5224LWight John M · Merrimack, NHBuilt 1967 · S/N 28-4518 N5224TPerkins Barber Shop · Jennings, LABuilt 1972 · S/N 28-7205248 N52250Lowcountry Flight LLC · Johns Island, SCBuilt 1980 · S/N 17274460 N52252Bos John D · Locust Grove, GABuilt 1980 · S/N 17274461 N5225DMustang Sally Aviation LLC · Camden, SCBuilt 1979 · S/N 17272457 N5225UMagic World Ky LLC · Sulphur, KYS/N 172RG0289 N5225WAll The Way Up Aviation LLC · Valrico, FLBuilt 1962 · S/N 28-262 N52261Christiansen Aviation LLC · Wilmington, DEBuilt 1980 · S/N 17274465 N52267Olds Forge Flyers Inc · Lansing, MIBuilt 1980 · S/N 17274471 N5226JMcgreen John R · Albany, NYBuilt 1980 · S/N 17273740 N5226LVancura Aviation LLC · Seffner, FLBuilt 1967 · S/N 28-4520 N5226MTrader Robert D · Madison, INBuilt 1978 · S/N M-2014 N5226WStatesboro Dental Associates Pe · Statesboro, GABuilt 1962 · S/N 28-264 N52272Above The Haze LLC · San Lorenzo, CABuilt 1981 · S/N 17274474 N52275California Airways LLC · Hayward, CABuilt 1980 · S/N 17274475 N52279Bateman Justin · Lindale, TXBuilt 1981 · S/N 17274478 N5227BSasse Jonathan D · Lubbock, TXBuilt 1956 · S/N 1090 N5227DTahoe Arrows LLC · South Lake Tahoe, CABuilt 1979 · S/N 17272458 N5227EAce Of Spades Aviation LLC · Las Vegas, NVS/N 17271782 N5227LPeter David A · Anderson, INBuilt 1967 · S/N 28-4521 N52280Southern Air LLC · Marissa, ILBuilt 1980 · S/N 17274479 N52286Whitair LLC · Henderson, NVBuilt 1980 · S/N 17274482 N52289Moore Daniel W · Valparaiso, INBuilt 1980 · S/N 17274483 N5228EMayberry Aviation Inc · Mount Airy, NCBuilt 1978 · S/N 17271783 N5228LWilliam C New Aviation Services LLC · Morgan City, LAS/N 28-4522 N5228RMtc Leasing LLC · Sandersville, GABuilt 1974 · S/N 17263442 N52290Aa-Aero Inc · Fairfield, NJBuilt 1980 · S/N 17274484 N5229DMiskell Christopher S · Senoia, GABuilt 1979 · S/N 17272459 N5229EZak Leo P · Oakdale, PABuilt 1978 · S/N 17271784 N5229ROcala Aviation Services Inc · Ocala, FLBuilt 1974 · S/N 17263443 N5229WPhilips Loren K · San Diego, CABuilt 1962 · S/N 28-267 N522BBolster Stacey · Williamsburg, VABuilt 1956 · S/N 18-4788 N522CBVancil Jon D · Collierville, TNBuilt 1960 · S/N 24-1939 N522DOlson Douglas L · Gowrie, IABuilt 2019 · S/N 001 N522DCBateson Mark A · Roseville, CABuilt 1974 · S/N 17263169

Back to AD 79-10-03 R2