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.

N3744UCristiani Sandra Elizabeth · Miami, FLBuilt 1981 · S/N 318312006 N3746PSale Reported · Fort Lauderdale, FLSale reported, canceledS/N 31-7752095 N374HPParrish Blake · Seminole, TXBuilt 2002 · S/N 3257274 N374KCHostetter Swinea Aviation LLC · Dickson, TNBuilt 2005 · S/N 4636374 N374MEKelley Aviation LLC · Crescent, IABuilt 2000 · S/N T20608223 N374PDavhen Aero LLC · Anderson, SCBuilt 1974 · S/N 27-7405410 N375CThornhill Jared Wayne · Shallowater, TXBuilt 2003 · S/N 3255002 N3760EWells Flying Services LLC · Holdrege, NEBuilt 1978 · S/N 36-7960064 N3767QParsons John C · Wichita, KSBuilt 1977 · S/N 32R-7780322 N376HCMfd Aviation Inc · Middletown, DEBuilt 1976 · S/N 32R-7680322 N376MESpirit Air Inc · Salmon, IDBuilt 2000 · S/N T20608225 N376NCLima Delta Company Trustee · New Castle, DEBuilt 1977 · S/N 31-7852048 N3776TFractional Villas Inc · Del Mar, CABuilt 2004 · S/N T18208314 N377CValiair Limited Company Trustee · Casper, WYBuilt 2005 · S/N 2222 N377DWSoutheastern Aircraft Inc · Birmingham, ALBuilt 1965 · S/N 27-3063 N377HAGrasse Louis Phillip Trustee · Saint Louis, MOBuilt 2004 · S/N T20608499 N377HCHigh Altitude Aviation LLC · High Point, NCBuilt 2002 · S/N 4636332 N377JRTrinity Aviation LLC · Oklahoma City, OKBuilt 1969 · S/N 32-11 N377MEBrandywine Enterprises Lp · Beverly Hills, CABuilt 2000 · S/N T20608226 N377RTElevated Aviation LLC · Silt, COS/N 3257377 N377SMJrt Flying Co · Roanoke, VABuilt 1977 · S/N 32R-7780223 N377USEaton Brian · Tampa, FLBuilt 2005 · S/N 27-0337 N3785ERegistration Pending · Sabin, MNRegistration pendingS/N 36-7860077 N378HPBelair Venice Aviation LLC · Osprey, FLBuilt 2004 · S/N 3257347 N378MECamelot Aviation LLC · Phoenix, AZBuilt 2000 · S/N T20608228 N378MMBento De Deus Amarildo · Margate, FLBuilt 1978 · S/N 31-7812118 N378MSJulius Kaleb · Tucson, AZBuilt 2002 · S/N T18208082 N379BFDay Darrell Rodney · Sahuarita, AZBuilt 2004 · S/N T18208253 N379GPGreat Pacific Aviation Services Inc · Grants Pass, ORBuilt 2005 · S/N T18208379 N379HPLiquid Transport Inc · Camilla, GABuilt 2004 · S/N 3257353 N37CKRichardson Dean · Saint Thomas, VIBuilt 1962 · S/N 500A-1251-76 N37GCKoumi Enterprises LLC · Houston, TXBuilt 2002 · S/N 3257273 N37REGiroux Aeronautical Company LLC · Fulton, NYBuilt 1976 · S/N 32R-7780114 N37RTPlane Fun Inc Tr Trustee · Snellville, GABuilt 1997 · S/N 4636082 N3800WJdj Transport LLC · Wilmington, DEBuilt 1966 · S/N 32-40128 N380CASky West Aviation Inc Trustee · Albuquerque, NMBuilt 1999 · S/N 3257080 N38127Trager Limestone LLC · Chillicothe, MOS/N 32R-7780387 N381CBGrubbs Steven O · Bellaire, TXBuilt 1981 · S/N 32R-8129068 N381HPHopkins George · West Covina, CABuilt 2005 · S/N 3257374 N381KHPhoenix Fire Protection LLC · Nampa, IDBuilt 2005 · S/N 27-0345 N38205Albright John A · Richmond, INBuilt 1977 · S/N 32R-7780403 N382HP382 Hp LLC · Pt Pleasant Beach, NJBuilt 2006 · S/N 3257411 N382JMGullicksrud Mark Robbe · Strum, WIBuilt 1981 · S/N 32R8229026 N38331Johnston Craig J · Ocean City, NJBuilt 1977 · S/N 32-7740082 N38334Gsm Air LLC · Old Tappan, NJBuilt 1977 · S/N 32R-7780415 N3838EPiper Aircraft Inc · Vero Beach, FLBuilt 1978 · S/N 36-7960068 N3839EPiper Aircraft Inc · Vero Beach, FLBuilt 1978 · S/N 36-7960069 N383CSven 1 LLC · Center Moriches, NYBuilt 2001 · S/N 3257258 N38597Bad Dog Aviation Inc · Meridianville, ALBuilt 1977 · S/N 32R-7780445 N385RMG Force Air LLC · Columbus, OHBuilt 1978 · S/N 31-7852125

Back to AD 81-12-06 R1