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.

N128TBlakesmith Don G · London Mills, ILBuilt 1990 · S/N 770 N128VMThomas Lucas G · Beebe, ARBuilt 2017 · S/N 585-2017 N128VUTiger 2 Flying Club LLC · Geneseo, ILBuilt 1991 · S/N 10067 N128YGorge Flight LLC · White Salmon, WABuilt 2016 · S/N 1128 N12901American Patrols Inc · Midland, TXBuilt 1973 · S/N 17262356 N12902Total Flight Aircraft Leasing LLC · Apex, NCBuilt 1973 · S/N 17262357 N12908M & R Management Consulting Inc · Fort Meade, FLNon-citizen corporation, flight hours not reportedS/N 17262362 N1290FKilm LLC · Wilmington, NCBuilt 2007 · S/N 18282045 N1290JKrister Robert A · Kent, OHBuilt 1975 · S/N 290 N12916Jacobs Airways Inc · Wilson, WIBuilt 1973 · S/N 17262369 N12917Dewhurst Donna A · Anchorage, AKBuilt 1973 · S/N 17262370 N12918Ashland/Boyd County Regional Airport Authority · Worthington, KYBuilt 1973 · S/N 17262371 N12919Gibson Aviation Services LLC · Menomonie, WIBuilt 1973 · S/N 17262372 N1291ASeale Sidney Joseph · Condon, ORBuilt 1951 · S/N 18-1094 N1291CVand Flyve Klub · Newfolden, MNS/N 18-2502 N1291FRegistered aircraftBuilt 1979 · S/N 17272986 N12923Roberts Cody A · Lueders, TXBuilt 1973 · S/N 17262375 N12926Norton Boe L · Carlsbad, NMBuilt 1973 · S/N 17262378 N1292CTrout Island Transit LLC · Glen Ellyn, ILBuilt 1977 · S/N 17702696 N1292JSoutheast Michigan Aircraft Sales Inc · Blissfield, MIBuilt 1975 · S/N 292 N1292PEm Turbines Corp · Fort Lauderdale, FLS/N 23-327 N1292UFlynn James M · Plain City, OHBuilt 1976 · S/N 17266986 N1292XBurns Barry D · Amarillo, TXBuilt 1963 · S/N 165 N12931Walden David C · Mesa, AZBuilt 1973 · S/N 17262382 N12933Van Anda Aviation LLC · Apopka, FLBuilt 1973 · S/N 17262384 N12935Ray Aviation LLC · Burkett, TXBuilt 1973 · S/N 17262386 N12936Quinlan Patrick J · Cooper City, FLBuilt 1973 · S/N 17262387 N1293FT-Craft Aero Club · Nampa, IDBuilt 1979 · S/N 17272987 N1293TN1293t LLC · Wilmington, DES/N 34-7250283 N12940Buffoon Flying Club · Mansfield, OHBuilt 1973 · S/N 17262388 N12943Titsworth R G · Seekonk, MABuilt 1973 · S/N 17262415 N12947Alltek Lebelle Ltd · Wilmington, DEBuilt 1973 · S/N 17262393 N1294CJel Imaging Services LLC · Rochester, NYFirst renewal noticeBuilt 1977 · S/N 17702698 N1294FClover Park Technical College · Lakewood, WABuilt 1979 · S/N 17272988 N1294XMcglynn Brian · Friday Harbor, WABuilt 1963 · S/N 167 N12951Huestis Peggy J · Havre, MTS/N 17262397 N12952Wesselhoff Rick · Sedona, AZBuilt 1973 · S/N 17262398 N12953Witmer Travis R · Odenton, MDBuilt 1973 · S/N 17262399 N12955American Patrols Inc · Midland, TXBuilt 1973 · S/N 17262400 N1295AJenski Kobie · Sutton, AKBuilt 1951 · S/N 18-1098 N1295TLutz Brian · Carmel, INBuilt 1972 · S/N 28-7205278 N1295URegistration Pending · Monroe, WIRegistration pendingBuilt 1976 · S/N 17266989 N1295XOz Aviation Inc · Cottonwood Falls, KSBuilt 1963 · S/N 168 N12960Hennessee Timothy H · New Braunfels, TXBuilt 1973 · S/N 17262405 N12968Rtd Aviation LLC · Hillsborough, NJBuilt 1973 · S/N 17262413 N1296CLogan Tom B Trustee · Coeur D Alene, IDBuilt 1977 · S/N 17702699 N1296UKirk Claire Y · Huntington Beach, CABuilt 1976 · S/N 17266990 N1296XFox Judy · Ridgefield, WAS/N 169 N12973Mor Aviation LLC · Gaithersburg, MDBuilt 1973 · S/N 17262418 N12974Forest Ken W · Wales, NDBuilt 1972 · S/N 17262419

Back to AD 81-18-04 R2