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.

N4877LTxp Designs LLC · Jasper, INS/N 28-4243 N4878AMallek Edward J · Fairbanks, AKBuilt 1956 · S/N 18-4977 N4878LPeg Aviation LLC · Cedar Hill, TNBuilt 1967 · S/N 28-4244 N4878TLorbiecki John E · Hubertus, WIS/N 28-7205214 N4879DMorey Airplane Company Inc · Middleton, WIBuilt 1979 · S/N 17272384 N4879TCombs Kenneth E · Canyon, TXBuilt 1972 · S/N 28-7225228 N487FLCarr Richard L · Cameron, WIBuilt 1971 · S/N 28-7125297 N4880FFkm Air Shuttle LLC · Brooklyn, NYBuilt 1979 · S/N 17273095 N4880GCifelli George J · Dothan, ALFirst renewal noticeBuilt 1979 · S/N 17273427 N4880LHigginbotham Rome A · Zanesville, OHBuilt 1967 · S/N 28-4246 N4880TItechtives Company LLC · Purcellville, VABuilt 1972 · S/N 28-7225229 N4881AAmstrup Jeremy T · Fairbanks, AKS/N 18-4981 N4881EFulltron Aviation LLC · Springfield, MOBuilt 1978 · S/N 17271672 N4881LHoneycutt Stephen D · Ukiah, CABuilt 1967 · S/N 28-4247 N4881TFuller Aire Inc · Wilmington, DEBuilt 1972 · S/N 28-7205215 N4882AWilliams Donald B · Wingate, NCS/N 18-4982 N4882LArapahoe Flight Club LLC · Colorado Springs, COBuilt 1967 · S/N 28-4248 N4883GPlane Nuts Aviation LLC · Livingston, LABuilt 1979 · S/N 17273430 N4883LMeixel Aviation LLC · Starbuck, MNBuilt 1967 · S/N 28-4249 N4884AGarfield Joe T · Morgan, UTBuilt 1956 · S/N 18-4985 N4885DSpartan National Holdings LLC · Missoula, MTBuilt 1979 · S/N 17272386 N4885GS&P Aviation LLC · Albuquerque, NMS/N 17273432 N4885LMaximize Solutions Inc · Swan Lake, NYBuilt 1967 · S/N 28-4251 N4886ACook Timothy D · Ashville, NYBuilt 1956 · S/N 18-4987 N4886GSkycrafters Inc · Johnson City, TNFirst renewal noticeBuilt 1979 · S/N 17273433 N4886LNortheast Florida Aero Club Inc · Fleming Island, FLBuilt 1967 · S/N 28-4252 N4887GSouthern Aero LLC · Homestead, FLBuilt 1979 · S/N 17273434 N4887TRoe John C · Bonners Ferry, IDS/N 28-7225230 N4888G578 Airplane Leasing Inc · Kissimmee, FLS/N 17273435 N4888TTevik Michael A · Provo, UTBuilt 1972 · S/N 28-7225231 N4888ZFrancom Jeffery S · Malad City, IDS/N 22-8470 N4889DPink Skies Inc · Willoughby, OHBuilt 1979 · S/N 17272387 N4889GKittitas Aero Inc · Kittitas, WABuilt 1979 · S/N 17273436 N4889LWerner Joseph H · Wauconda, ILBuilt 1967 · S/N 28-4255 N4889TS&P Aviation LLC · Albuquerque, NMS/N 28-7205217 N488CMEmery Kenneth Russell Jr · Odessa, FLBuilt 2011 · S/N 73322 N488JWKagey David M · Seabrook, TXBuilt 1972 · S/N 17261113 N488LGErnst Donald E · North Pole, AKBuilt 1975 · S/N 14175 N488RRMenke Rex A · Medical Lake, WABuilt 1972 · S/N 93 N488XHahn Jesse J · Cedar Rapids, IAS/N 5111 N489Snyder Ralph J · Colorado Springs, COBuilt 1993 · S/N 20003 N4890PSale Reported · Willow, AKSale reportedBuilt 1961 · S/N 18-7762 N4890UUniversity Of Oklahoma · Norman, OKBuilt 2005 · S/N 2842235 N4891JHarris Aircraft Leasing Co · Oklahoma City, OKBuilt 1979 · S/N 17273691 N4891LToga LLC · Dayton, VABuilt 1967 · S/N 28-4258 N4891TRoss Stephen C · Santa Fe, NMBuilt 1972 · S/N 28-7205219 N4893ELjl & D Inc · Wilmington, DEBuilt 1978 · S/N 17271673 N4893GBoldflight LLC · Greenwood, INBuilt 1979 · S/N 17273440 N4893JMartineau Aircraft Inc · Butte, MTBuilt 1979 · S/N 17273692 N4894LPeairs Gregory Ross · Sacramento, CABuilt 1967 · S/N 28-4261

Back to AD 79-10-03 R2