Skip to content

Registered aircraft · 5,075

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-19-03-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-19-03-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-19-03-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-19-03-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-19-03-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-19-03-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.

N8853CEuropa Aero LLC · Bucyrus, OHBuilt 1976 · S/N 32R-7680141 N8853PGebhart Kevin E · Burley, IDBuilt 1965 · S/N 24-4309 N8858PMachmiller A A · San Jose, CABuilt 1965 · S/N 24-4315 N8859PGowins John C · New Philadelphia, OHBuilt 1965 · S/N 24-4317 N885HAFox Airways LLC · Wasilla, AKS/N 31-7405416 N8861PForney Garry L · El Centro, CABuilt 1965 · S/N 24-4318 N8862VInternational Air Services Inc Trustee · Carson City, NVBuilt 1971 · S/N 31022 N8864VAnthony Baruth · Saint Joseph, MOBuilt 1971 · S/N 32-48 N8865PBrown Travis E · Leicester, NCBuilt 1965 · S/N 24-4322 N8868VWard Steven E · Wilbur, WABuilt 1972 · S/N 32-62 N8870VOklahoma Historical Steam Engine Museum Foundation · Oklahoma City, OKS/N 32-52 N8872PBlackburn Robert F · Georgetown, TXBuilt 1965 · S/N 24-4329 N8873PTailwind Auditing Group LLC · Godley, TXBuilt 1965 · S/N 24-4330 N8878PHudson Albert Denning · Cornelius, NCBuilt 1965 · S/N 24-4337 N8881PIce Randall R · Pierre, SDBuilt 1965 · S/N 24-4340 N8883PFlynn James Jay · Seneca, SCBuilt 1965 · S/N 24-4342 N88847So-Do Holdings LLC · Monticello, GAS/N 32R-7680354 N8888X82 Saratoga LLC · Bryant, ARBuilt 1989 · S/N 4622078 N888EBCharcoals Smokehouse LLC · Katy, TXBuilt 1977 · S/N 32R-7780194 N888EGMooney N888eg LLC · Granbury, TXBuilt 1989 · S/N 27-0021 N888JJGst Inmotion LLC · Kalispell, MTBuilt 1978 · S/N 317852078 N888LMAir Mods And Repair · Robbinsville, NJS/N 31-7405464 N888PCAirmonarc LLC · Orlando, FLBuilt 1981 · S/N 31-8152086 N888PEPacific Flight Academy LLC · Honolulu, HIBuilt 1977 · S/N 27-7754066 N888RJMongini David · Cottonwood, AZBuilt 1973 · S/N 27-7305139 N888TMFive G Aviation LLC · Nampa, IDBuilt 1974 · S/N 32-7440132 N888WPVantage Point Aviation LLC · Ormond Beach, FLBuilt 1966 · S/N 27-3561 N888YAAds-B Technologies LLC · Anchorage, AKS/N 31-7305076 N8890PElliott Charles · New Smyrna Beach, FLBuilt 1965 · S/N 24-4242 N8891PTobias Ethan · West Haven, UTBuilt 1965 · S/N 24-4344 N8892PN8892p LLC · Glendale, AZBuilt 1965 · S/N 24-4345 N8893ERegistration Pending · Pompano Beach, FLRegistration pendingBuilt 1976 · S/N 32R-7680186 N8894PGarms Walter I III Trustee · Berkeley, CABuilt 1965 · S/N 24-4347 N8897PFey Ray D · Middleton, WIBuilt 1965 · S/N 24-4351 N8899PLavoie Paul · Macon, GAS/N 24-4353 N889ACKdx Air Ventures LLC · Naples, FLS/N 60-8423024 N88CMTurner Ronald A · Tulsa, OKBuilt 1974 · S/N 61-0150-080 N88CXChamplin Aviation LLC · Kerens, TXBuilt 1974 · S/N 61P-0160-002 N88HLLiberty Aero LLC · Carlsbad, NMS/N T18208377 N88NPRegistration Pending · Saint Petersburg, FLRegistration pendingBuilt 1976 · S/N 27-7754006 N88PZ88pz LLC · Clifton Park, NYS/N 27-7754112 N88RARusso Mark · Stevensville, MTBuilt 1996 · S/N 4636034 N88RHKeystone Flyer LLC · Avon, INBuilt 1975 · S/N 32R-7680065 N88TGMakushin Logistics LLC · Fairbanks, AKBuilt 1984 · S/N 31-8452020 N88TLAh Legacy LLC · Orlando, FLBuilt 1980 · S/N 31-8152066 N88VBBjelland Richard A · Galt, CABuilt 1967 · S/N 27-3609 N88ZMFlorida Aero Services Sales Division Inc · Brandon, FLBuilt 1976 · S/N 31-7752016 N8900PCabrejos-Guillen Roberto · Wichita, KSBuilt 1965 · S/N 24-4355 N8901PRead Robert S · Peoria, AZBuilt 1966 · S/N 24-4356 N8902PFarris Greg T · Ann Arbor, MIBuilt 1966 · S/N 24-4357

Back to AD 84-19-03 R1