Skip to content

Registered aircraft · 5,102

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-12-06-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:81-12-06-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:81-12-06-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:81-12-06-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:81-12-06-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:81-12-06-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.

N68BKKrauch William K Co-Trustee · Santa Ynez, CABuilt 2005 · S/N T18208398 N68DSkaggs Randall D · Sacramento, CABuilt 1973 · S/N 74-31072 N68JDCorman Justin W · Bridgeport, NEBuilt 1974 · S/N 32-7440130 N68JTVallandi Amy E · Las Vegas, NVBuilt 1989 · S/N 904 N68KSeymour Robin · Woodland Hills, CABuilt 1976 · S/N 32R-7680227 N68MWCsc Delaware Trust Co Trustee · Wilmington, DEBuilt 1975 · S/N 27-7554126 N68SEGateway Flight Center LLC · Port Lavaca, TXS/N 27-3780 N6902YJ L Darr & Son Inc · High Point, NCBuilt 1969 · S/N 27-4256 N6904YUnited Jet Sales Inc · Newark, DEBuilt 1969 · S/N 27-4259 N6906JBas Part Sales LLC · Greeley, COBuilt 1976 · S/N 32R-7680383 N6907JFisher Bradley J · Bryant, INBuilt 1976 · S/N 32R-7680384 N690RRCentral Airlines Inc · Leawood, KSBuilt 1962 · S/N 500B-1169-88 N6911YDelaware Aircraft Trust LLC Trustee · New Castle, DEBuilt 1969 · S/N 27-4266 N6916YDk1 Aviation LLC · Fayetteville, NCBuilt 1969 · S/N 27-4272 N691MAMitchell Martin · Alpine, CABuilt 2002 · S/N 3257291 N691SCSouthern Cross Aircraft LLC · Fort Lauderdale, FLS/N 1552 N692DWBroyles Danny Keith · New Castle, INBuilt 2005 · S/N 3257384 N6934JCopaair Maintenance Services Inc · Indiantown, FLBuilt 1976 · S/N 32R-7680389 N693MEDicky David J · Sierra Vista, AZS/N 3228 N693TCBrooks Janousek LLC · Kingsford, MIBuilt 1997 · S/N 20018 N6940FRebel Ranch LLC · Glenwood, ARBuilt 1976 · S/N 32R-7780050 N6943YAce Tomato Co LLC · Daytona Beach, FLBuilt 1969 · S/N 27-4350 N6944APacific Fleet Aviation LLC · Rochester, NYBuilt 1979 · S/N 27-7954109 N6944YLg Aztec LLC · Boynton Beach, FLBuilt 1969 · S/N 27-4304 N694BKBell Bruce · Desert Aire, WABuilt 1969 · S/N 1851582 N694BWOtter Creek Aviation LLC · Columbus, GABuilt 2004 · S/N T18208262 N694DBHammond Flying Club Inc · Covington, LABuilt 1975 · S/N 32-7540087 N694PCBajedi Aviation LLC · Lewes, DEBuilt 2002 · S/N 3257305 N694RJAtlas 182rj LLC · Port Townsend, WABuilt 2005 · S/N T18208473 N6952YPorterfield Brian B · Wasilla, AKBuilt 1969 · S/N 27-4316 N6953JDubois Marcus S · Olive Branch, MSBuilt 1976 · S/N 32R-7680393 N6954JHughston Thomas Price · NorfolkBuilt 1976 · S/N 32R-7680394 N6955YN6955y LLC · Knoxville, IABuilt 1969 · S/N 27-4320 N6956YTolsma Michael J · Hawthorne, NJBuilt 1969 · S/N 27-4321 N6961JBaja Airventures Inc · Chula Vista, CABuilt 1976 · S/N 32R-7680395 N6962SYeaman John Robert IV · Aroda, VABuilt 2000 · S/N 4636272 N696JANational Industrial Services LLC · Kingshill, VIBuilt 1965 · S/N 27-2924 N6970YBell Daniel E · Alexandria, KYBuilt 1969 · S/N 27-4337 N6971YNovember Nine One Four Eight Juliet LLC · Fulton, MOBuilt 1969 · S/N 27-4338 N697WHAgri Enterprises LLC · Hopkinsville, KYBuilt 1983 · S/N 31-8352008 N698HNelson Bobby E · Naples, FLBuilt 1968 · S/N 27-4106 N698VWSheppard Louis A · Queens Village, NYBuilt 1974 · S/N 31-7405408 N699MDJvation LLC · Belgrade, MTBuilt 1994 · S/N 4622159 N699TBUS Anesthesia Consultants LLC · Chesterfield, MOBuilt 1994 · S/N 4622158 N69CPBuena Vista Hunting LLC · Eagle Pass, TXBuilt 2005 · S/N T20608564 N69FMAirtime LLC · South Lyon, MIBuilt 1976 · S/N 32R-7680200 N69JWWarrior Aviation LLC · Dollar Bay, MIBuilt 1972 · S/N 31036 N69LHGraham Jack · Hamilton, TXBuilt 1977 · S/N 32R-7780323 N69LVTbd Air LLC · Chatham, MABuilt 2001 · S/N 3257229 N69MKFisher Jack C · Ashland City, TNBuilt 1998 · S/N 3257063

Back to AD 81-12-06 R1