Skip to content

Registered aircraft · 25,364

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:80-25-07-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:80-25-07-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:80-25-07-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:80-25-07-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:80-25-07-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:80-25-07-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.

N116PCGlobal Piloting Solutions LLC · Mankato, MNBuilt 2001 · S/N 1320-2001 N116SDA L Aviation LLC · Boiling Springs, SCS/N 359-73 N11702Tailwheeling It LLC · Algoma, WIBuilt 1972 · S/N 317-72 N11704Jackman William L · Newman Lake, WAS/N 857-72 N11706Hershberger Brian K · Wrightwood, CABuilt 1972 · S/N 319-72 N11707Catfish Express Inc · Inverness, MSBuilt 1972 · S/N 15-72 N11709Hutchins Reid C · Hanover, NHBuilt 1972 · S/N 859-72 N1170CPapendick Greg J · Hudsonville, MIS/N 24-1313 N1170GStephansky John J Jr · Spotsylvania, VABuilt 1982 · S/N 24-1315 N1170MBryson William H III · Cook, MNBuilt 1969 · S/N 17258670 N1170XMueller Anne H · Blairsville, GABuilt 1982 · S/N 24-1329 N11719Relkar Holdings Inc · Newark, DEBuilt 1982 · S/N 24-1325 N1171LN1171l LLC · Newport News, VABuilt 1982 · S/N 24-1330 N1171MProfessional Flyers Corporation · Wilmington, DEBuilt 1982 · S/N 24-1317 N1171NGies Florian J IV · King Hill, IDS/N 24-1629 N1171PRhames Curtis L · Farmington, NMS/N 24-1331 N1171RHillier Jared Christian · Carthage, MOBuilt 1982 · S/N 24-1320 N1171WEisenmenger James P Trustee · Yankton, SDBuilt 1982 · S/N 24-1256 N11720Mcfarlane Kevin E · Dubuque, IABuilt 1972 · S/N 860-72 N11721Yague-Martinez Eloy · Rochester, NYBuilt 1972 · S/N 320-72 N11723Rader Mark Todd · Deland, FLBuilt 1975 · S/N 17702361 N11724N11724 LLC · San Marcos, TXBuilt 1982 · S/N 24-1327 N1172MTodd Kevin E · Bismarck, NDBuilt 1969 · S/N 17258672 N11730Sendelbach John W · Cochrane, WIBuilt 1975 · S/N 17702362 N1173APouk Douglas A · Saint Louis, MOBuilt 1982 · S/N 24-1333 N1173BHicks Harlon Keith · Haleyville, ALBuilt 1994 · S/N 24-3326 N1173CHolland Todd D · Mendota, ILBuilt 1977 · S/N 17702679 N1173MFlathead Lake Aviation LLC · Polson, MTBuilt 1969 · S/N 17258673 N1173NDicicco Lenny M · Asheville, NCBuilt 1982 · S/N 24-1335 N1174EInman James Dylan · Parsons, TNS/N 1228-78 N1174MWhitted Danny E · Candler, NCBuilt 1969 · S/N 17258674 N11756Creswell Philip M · Camden, ALBuilt 1975 · S/N 17702365 N1175ENannini Gary S · Lincoln City, ORBuilt 1977 · S/N 314-77 N1176EIrving Holdings LLC · Greensboro, NCBuilt 1977 · S/N 988-77 N1176UPlane Leasing LLC · Wilmington, DEBuilt 1976 · S/N 17266877 N11771Boss Gary W · Bronston, KYBuilt 1975 · S/N 17702366 N1177BTakacs John Paul III · Colorado Springs, COBuilt 1991 · S/N 651-91 N1178COliveira Frank Jr · Pawtucket, RIBuilt 1977 · S/N 17702680 N1178MLehman David G · Kent, WABuilt 1969 · S/N 17258678 N1178UWaco Diamond Star LLC · Niceville, FLS/N 21064671 N11799Borba Steven D · Woodland, CABuilt 1975 · S/N 17702369 N1179EPlane Air LLC · Paducah, KYBuilt 1977 · S/N 1220-77 N1179MBartholomew Thomas C · Stanwood, WABuilt 1969 · S/N 17258679 N1179UBadgerland Aero Club Inc · Fitchburg, WIBuilt 1976 · S/N 17266880 N117ABHellickson Brad · Corona, CAS/N 17271253 N117ATHill George R · Calhoun Falls, SCBuilt 1978 · S/N 38-78A0631 N117CPC P Aviation Inc · Santa Paula, CABuilt 1999 · S/N 1275-99 N117DFMandell Thomas · Roseville, CABuilt 1985 · S/N 24-1542 N117JBGenerations Flying Club LLC · Washington, MOBuilt 1978 · S/N 17270644 N117MMMelton Charlie W · Grand Saline, TXBuilt 1968 · S/N 17700872

Back to AD 80-25-07 R1