Skip to content

Registered aircraft · 40,401

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.

N127ATAirline Transport Professionals Corp Of USA · Wilmington, DEBuilt 2000 · S/N 4496035 N127AVPlane Fun Inc Tr Trustee · Snellville, GABuilt 1984 · S/N 28-8490077 N127EPAnnonsen Johnny · Dix Hills, NYBuilt 1985 · S/N 172-76481 N127FRYoon Paul · Saint David, AZS/N 17275292 N127JNNewman Jimmie L · Davenport, FLBuilt 2007 · S/N 24735 N127KDSouthmost Aviation Inc · Brownsville, TXBuilt 1976 · S/N 17267210 N127KJSky Flowers Holding Group LLC · Sunrise, FLS/N 10248 N127LFFisher Nicholis W · Springfield, LAS/N 27 N127MDCosbie Lee R · Tuscumbia, ALBuilt 1963 · S/N 28-1503 N127PSParsa Aviation LLC · Boca Raton, FLS/N 6010 N127RBushby Harvey M Jr · Minonka, ILBuilt 1995 · S/N M-II-1110 N127TGEberle Brian J · Newnan, GABuilt 2005 · S/N 21321 N127TZMeng-Hannan Construction Inc · Portland, ORBuilt 2000 · S/N 2108 N127VATelkamp Gary O · Rapid City, SDBuilt 2003 · S/N 90127 N127WMMagnum Consulting Group Inc · Scottsdale, AZBuilt 1993 · S/N 1369 N12801Cone Ted · Wayne, NJBuilt 1973 · S/N 17262271 N12805Bemidji Aviation Services Inc · Bemidji, MNBuilt 1973 · S/N 17262275 N12819Stewart Todd L · Mooresville, NCS/N 17262288 N12820US Aviation Group LLC · Denton, TXBuilt 1973 · S/N 17262289 N12821Hayslett Norman L · Roscoe, MOBuilt 1973 · S/N 17262290 N12822Courtney Aviation LLC · Columbia, CABuilt 1973 · S/N 17262291 N1282URutledge James K Trustee · Colfax, CABuilt 1976 · S/N 17266977 N12830All Sports Aviation LLC · Spokane, WABuilt 1973 · S/N 17262296 N12831Bryant Kevin L · Terry, MSBuilt 1973 · S/N 17262297 N12833Kling Aviation Inc · Friendswood, TXBuilt 1973 · S/N 17262299 N12834High Flight Academy LLC · Allison Park, PABuilt 1973 · S/N 17262300 N12836Schlemmer Diane · Roswell, GABuilt 1973 · S/N 17262301 N1283UAtutis Michael F · Baldwinsville, NYBuilt 1976 · S/N 17266978 N12840Lanier Aviation LLC · Cleveland, GABuilt 1973 · S/N 17262304 N12849Ripa Christopher J · East Harwich, MABuilt 1973 · S/N 17262311 N1284NAbnc Air LLC · Wellington, FLS/N 28-7405076 N12860Solis Aviation LLC · Carroll, OHBuilt 1973 · S/N 17262319 N12865Flyright Aviation LLC · Columbus, OHBuilt 1973 · S/N 17262324 N12866Holmes Charles Trustee · Fort Madison, IABuilt 1973 · S/N 17262325 N12867Palm Grove Development Inc · Gray, GABuilt 1973 · S/N 17262326 N12868Gregg William V · Greensburg, PABuilt 1975 · S/N 17702390 N1286THeffelfinger Paul D · Seven Valleys, PABuilt 1972 · S/N 28-7205277 N12871Bemidji Aviation Services Inc · Bemidji, MNBuilt 1973 · S/N 17262330 N12872Advanced Aviation And Aircraft Rental LLC · Lawrenceville, GABuilt 1973 · S/N 17262331 N12874Mentone Flying Club Inc · Rochester, INBuilt 1973 · S/N 17262333 N12875Career Flight Training And Aircraft Rental LLC · Naples, FLBuilt 1973 · S/N 17262334 N12876Aerolanding LLC · Enterprise, ALBuilt 1973 · S/N 17262335 N12878M&M Bear Necessities LLC · Newellton, LABuilt 1973 · S/N 17262337 N1287UTrekraken Aviation LLC · Scottsdale, AZBuilt 1976 · S/N 17266981 N12880Aerial Holdings LLC · Lewes, DEBuilt 1973 · S/N 17262339 N12883Rpm Aero LLC · Lincolnwood, ILBuilt 1973 · S/N 17262340 N12884Registered aircraftBuilt 1973 · S/N 17262341 N12885Above & Beyond Aviation LLC · Sandy Hook, CTBuilt 1973 · S/N 17262342 N12886Wings Over Texas Holdings LLC · Denton, TXBuilt 1973 · S/N 17262343 N12887Slipstream Aviation LLC · Calera, ALBuilt 1973 · S/N 17262344

Back to AD 79-10-03 R2