Skip to content

Registered aircraft · 54,016

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-20-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:87-20-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:87-20-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:87-20-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:87-20-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:87-20-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.

N111ZYSkywarrior Flight Training Inc · Pensacola, FLBuilt 1986 · S/N 17276611 N11204Hudson Daryl J · Redwood Valley, CABuilt 1973 · S/N 15075252 N11208Cape Fear Aviation Maintenance LLC · Fayetteville, NCBuilt 1973 · S/N 15075255 N11209Pendragon Aviation LLC · Sylvania, GABuilt 1973 · S/N 15075256 N1120DCompher Charles D · Berryville, VABuilt 1966 · S/N 17254131 N1120FHaidle Wayne M · Bismarck, NDBuilt 1966 · S/N 17254715 N1120VKodiak Marine Construction · Oakley, IDBuilt 1976 · S/N U20603130 N1121TWaddell Richard K Jr · Loveland, COBuilt 1967 · S/N 18258703 N1121YShaw Michael B · Ridgeland, WIBuilt 1962 · S/N 15059521 N11226Box Jon A · Carrizo Springs, TXBuilt 1975 · S/N 17702329 N11227Tribec Inc · Medina, OHBuilt 1973 · S/N 15075262 N11228N11228 LLC · Wheeling, ILBuilt 1973 · S/N 15075263 N1122FDollosso Frank G · Lakeport, CABuilt 1966 · S/N 17254717 N11231He Yaling · Grand Prairie, TXS/N 15075266 N11234Universal Airways Inc · Richmond, TXBuilt 1973 · S/N 15075269 N11236Cato Mark M · Clemson, SCBuilt 1973 · S/N 15075271 N11238Laguna Ulises Edgar · Waco, TXBuilt 1973 · S/N 15075272 N1123MGrey Robert J · La Madera, NMBuilt 1975 · S/N 18264227 N1123UTroy Investment Co 1 L P · Brownsville, TXBuilt 1982 · S/N 21064667 N11242Crook Robert W · Wichita, KSBuilt 1973 · S/N 15075275 N11243Aeronautical Technical Service Inc · Collierville, TNBuilt 1973 · S/N 15075276 N1124BAlaska Homestead Lodge Inc · Soldotna, AKBuilt 1957 · S/N 34259 N1124MRegistration Pending · West Branch, MIRegistration pendingS/N 17259804 N1124QDuren Virgil W · Bristow, INBuilt 1972 · S/N 15073164 N11251Air Flight Enterprises Inc · S Daytona, FLS/N 15075278 N11257Sale Reported · Eden Prairie, MNSale reportedS/N 15075279 N1125FAeropark LLC · Michigan City, INBuilt 1966 · S/N 17254720 N11262Locke Brian T · Andover, KSBuilt 1973 · S/N 15075282 N11268Bohl Howard M Jr · Long Beach, CABuilt 1973 · S/N 15075286 N1126AEberling Joan P · Central Point, ORBuilt 1977 · S/N 18265585 N1126CBriggs Jonathan · Merritt Island, FLBuilt 1981 · S/N R18201689 N1126MD2 Government Solutions LLC · New Bern, NCBuilt 1971 · S/N 17259803 N11271No Coop Cardinal LLC · Sonoma, CABuilt 1975 · S/N 17702330 N11272Williamson Brett O · Essex, MOBuilt 1973 · S/N 15075289 N1127FPricemeyer Aviation LLC · St Pete Beach, FLS/N 17254722 N1127YWong David · Torance, CABuilt 1962 · S/N 15059527 N11281Solovjev Jadranka · Sarasota, FLS/N 15075295 N11283J F Aviation Inc · Joliet, ILBuilt 1973 · S/N 15075297 N11285Northeast Florida Aero Club Inc · Fleming Island, FLBuilt 1973 · S/N 15075299 N11289Phelps Aero Co LLC · Salem, ORBuilt 1973 · S/N 15075302 N1128CGibbs Wyatt R · Lodi, CABuilt 1978 · S/N 21062711 N1128FLockridge James · Adairsville, GAS/N 17254723 N1128UElw Inc · Bonners Ferry, IDBuilt 1976 · S/N 17266857 N1128YPerez Donna · Chico, CABuilt 1962 · S/N 15059528 N11290Safety In Motion Flight Center Inc · Puyallup, WABuilt 1973 · S/N 15075303 N11295Bancroft David J · Rio, WIBuilt 1973 · S/N 15075305 N11297Raley James C · Brandon, SDBuilt 1973 · S/N 15075307 N11299Creech John M · Brentwood, TNS/N 15075309 N1129FKoch Bradley D · Billings, MTBuilt 1966 · S/N 17254724 N1129MTechair LLC · Playa Vista, CAS/N 17252240

Back to AD 87-20-03 R2