Skip to content

Registered aircraft · 81,720

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:81-18-04-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:81-18-04-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:81-18-04-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:81-18-04-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:81-18-04-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:81-18-04-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.

N127VGEvans James F · Columbus, GABuilt 1978 · S/N 32R-7885274 N127WMMagnum Consulting Group Inc · Scottsdale, AZBuilt 1993 · S/N 1369 N127XKilgore Sky LLC · Parker, AZBuilt 2004 · S/N 40.438 N12801Cone Ted · Wayne, NJBuilt 1973 · S/N 17262271 N12805Bemidji Aviation Services Inc · Bemidji, MNBuilt 1973 · S/N 17262275 N1280CRoesch Karl L · Arlee, MTBuilt 1953 · S/N 22-1078 N1280KChristiansen Aviation LLC · Wilmington, DEBuilt 2023 · S/N 172S13064 N1280TCertified Equipment Inspections LLC · Washington, PABuilt 1972 · S/N 28R-7235253 N1280XErlandson Michael D · Salt Lake City, UTS/N 153 N12819Stewart Todd L · Mooresville, NCS/N 17262288 N1281KKirkwood Billie R · El Paso, TXBuilt 2011 · S/N 24143 N1281QMaranatha Insurance Services Inc · Rancho Cucamonga, CABuilt 2006 · S/N 172S10333 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 N12828Fulwiler Air LLC · Green Bay, WIBuilt 1961 · S/N 3023 N1282CSpivey Harold E · Thomaston, GABuilt 1953 · S/N 22-1076 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 N1283AFritz David A · Wasilla, AKBuilt 1951 · S/N 18-1087 N1283CZawada Matthew J · Roberts, MTBuilt 1953 · S/N 22-1079 N1283HMurphy George W · Willow, AKS/N 15AC-299 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 N1284WBethel Don G · Bossier City, LABuilt 1967 · S/N 28R-30304 N1284ZDubose Alexander R · Durham, CABuilt 1961 · S/N TD-458 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 N1286JDillman Neal A · Davis, CABuilt 1975 · S/N 286 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 N1287ECrown Coast LLC · Costa Mesa, CABuilt 2006 · S/N 172S10335 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

Back to AD 81-18-04 R2