Skip to content

Registered aircraft · 22,416

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

N8193ZIa Il Termite & Pest Control Inc · Davenport, IABuilt 1980 · S/N 32R-8013091 N8194EBill W Chu Inc · Madera, CABuilt 1980 · S/N 32-8024024 N8194JTipton Aero Shares LLC · Fort Meade, MDBuilt 1982 · S/N 28-8216142 N8194KLawair Ltd · Mattoon, ILBuilt 1980 · S/N 32R-8013095 N81956Blue Skies Leasing Inc · Port Orange, FLBuilt 1982 · S/N 28-8290119 N8195EKummer Richard L · Dallas, TXBuilt 1982 · S/N 28-8290114 N8195WN7396w LLC · Coeymans Hollow, NYBuilt 1965 · S/N 28-2323 N8195YReynolds Richard T · Owens Cross Roads, ALBuilt 1980 · S/N 28-8016316 N8196NJensen Aviation LLC · Zephyrhills, FLBuilt 1969 · S/N 28-25394 N8196WRensberger Scott C · Lake Jackson, TXBuilt 1965 · S/N 28-2324 N81972Reile Roy H · Elmont, NYBuilt 1980 · S/N 28-8016318 N8197LGcg Aviation LLC · Fayetteville, GAS/N 32R-8229047 N8197PThrash St LLC · Lubbock, TXBuilt 1983 · S/N 32-8324002 N8197WRegistration Pending · Rifle, CORegistration pendingBuilt 1980 · S/N 32R-8029050 N81981Miloud Chadd K · Fort Worth, TXBuilt 1982 · S/N 28-8216147 N81988Kephart John M · Franklin, INBuilt 1982 · S/N 28-8216148 N8198HEckl James M · Florence, ALS/N 28-8090294 N8198NSpooner John R Jr · Atascadero, CABuilt 1969 · S/N 28-25397 N8198VRegion Flyers LLC · Valparaiso, INBuilt 1982 · S/N 28-8216145 N8198WGreenshields Brett William · Eastvale, CABuilt 1965 · S/N 28-2326 N8198ZPlatz Trevor · Pine Grove, CABuilt 1982 · S/N 28-8216146 N81991Pruitt Frank C · Winter Springs, FLBuilt 1980 · S/N 32-8006044 N8199YMartin Luciano Trustee · Yorba Linda, CABuilt 1980 · S/N 32-8006043 N819CWietbrock Douglas F · San Antonio, TXBuilt 2006 · S/N 3255049 N819JSZnamenacek Kevin L · Western, NEBuilt 1980 · S/N 28-8190044 N819PASkywest Leasing Inc · St George, UTBuilt 2019 · S/N 2881247 N819SBCarroll Justin · Harrisburg, NCBuilt 1978 · S/N 32R-7885131 N81BAAscent Aviation Inc · Van Nuys, CABuilt 1974 · S/N 28-7415440 N81DGRae Seth R · Spotsylvania, VABuilt 1967 · S/N 28-4579 N81ECWalker Robert · Chula Vista, CABuilt 1966 · S/N 28-10818 N81KLSt Pete Aviation Services LLC · Saint Petersburg, FLS/N 32-8106047 N81LCBynum Leo M · Albuquerque, NMBuilt 1981 · S/N 28-8111074 N81LMMission Flight Academy · Yucaipa, CABuilt 1969 · S/N 32-40699 N81MHSvedrovic Alex P · Waterbury, CTBuilt 1968 · S/N 28-24238 N81MMMangum Aviation Inc · Pasadena, TXBuilt 1980 · S/N 28-8090332 N81PKTier-1 Helicopters LLC · Hampton, GAS/N 3213023 N81PMSpinnaker Aviation LLC · Conroe, TXBuilt 1973 · S/N 28-7325314 N81PWHart Services LLC · Mt Pleasant, SCBuilt 1980 · S/N 32-8106002 N81STAxion Inc · Huntsville, ALBuilt 1980 · S/N 32-8024036 N82005S&H Leasing LLC · Sarasota, FLBuilt 1981 · S/N 28-8116286 N82008Craige Danny D Trustee · Durant, OKBuilt 1980 · S/N 32R-8029089 N8200VHills Holding · Newark, DEBuilt 1980 · S/N 28-8016319 N8200YCj Industries LLC · Chesnee, SCBuilt 1982 · S/N 32-8206032 N8200ZFlack Norma Jeanne · Fort Lauderdale, FLBuilt 1980 · S/N 28-8016320 N8201NLang Peter J · Coopersburg, PAS/N 28-25403 N8201W8201w General Partnership · Wilbraham, MAS/N 28-2330 N8202ERegistered aircraftBuilt 1982 · S/N 32R-8313014 N8202WN8202w LLC · American Fork, UTBuilt 1965 · S/N 28-2331 N8203CKoelsch Seed LLC · St John, KSS/N 3240938 N8203DVans Holding LLC · Canton, OHBuilt 1982 · S/N 28-8290120

Back to AD 87-08-08 R3