Registered aircraft · 11,798

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:2006-16-18-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:2006-16-18-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:2006-16-18-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:2006-16-18-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:2006-16-18-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:2006-16-18-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.

N525GKG Money LLC · Delavan, WIBuilt 1994 · S/N 525-0052 N525GLSk872 LLC · Wilmington, DES/N 525-0872 N525HCAircraft Trustee Services Inc Trustee · Dover, DEBuilt 1998 · S/N 525-0270 N525HLBank Of Utah Trustee · Salt Lake City, UTBuilt 2013 · S/N 525-0808 N525HMRegistered aircraftBuilt 2006 · S/N 525-0621 N525HQN525hq Aircraft Holdings LLC · Mount Pleasant, SCBuilt 2014 · S/N 525-0827 N525HSKen Dunbar & Sons Inc · Bakersfield, CABuilt 1993 · S/N 525-0035 N525HXValiair Lc Trustee · Casper, WYBuilt 1998 · S/N 525-0278 N525HYGp Farms LLC · Missoula, MTBuilt 1998 · S/N 525-0239 N525JCj525j LLC · Millersburg, OHBuilt 1997 · S/N 525-0184 N525JDCuprum Aviation LLC · Wellington, FLBuilt 2014 · S/N 525-0819 N525JESimply Living LLC · Fort Myers, FLBuilt 2002 · S/N 525-0493 N525JJReb Transporation LLC · Hattiesburg, MSBuilt 2002 · S/N 525-0497 N525JLMadison Air LLC · Big Sky, MTBuilt 2000 · S/N 525-0407 N525JMJ D Leasing LLC · Wilmington, DEBuilt 1996 · S/N 525-0134 N525JVJ P Ferguson Aviation LLC · Oxford, MSBuilt 1995 · S/N 525-0095 N525JWWashington Road Properties Level 2 LLC · Highlands, NCBuilt 1996 · S/N 525-0162 N525KAPhysical Systems Inc · Carson City, NVBuilt 1993 · S/N 525-0019 N525KBLast Bird LLC · Santa Fe, NMBuilt 2017 · S/N 525-0964 N525KHKh Aviation Tbm 850 LLC · Prospect Heights, ILBuilt 2016 · S/N 525-0908 N525KMYy LLC · Kalispell, MTBuilt 2001 · S/N 525-0472 N525KSNt Aviation LLC · Wichita, KSBuilt 1993 · S/N 525-0024 N525LAArkten Jet Partners LLC · Jonesboro, ARBuilt 2001 · S/N 525-0422 N525LEJet Options LLC · Indianapolis, INBuilt 2001 · S/N 525-0447 N525LKKovacs Louis Attila Trustee · Saratoga, CABuilt 1997 · S/N 525-0200 N525LMCth Rentals LLC · Halls, TNBuilt 2001 · S/N 525-0427 N525LPTeam Financial Inc · Birmingham, ALBuilt 1997 · S/N 525-0196 N525LWN525lw Corp Trustee · Wilmington, DEBuilt 1994 · S/N 525-0082 N525LXV2 Aviation LLC · Chattanooga, TNBuilt 1994 · S/N 525-0058 N525MBPortobello LLC · Fort Payne, ALBuilt 1993 · S/N 525-0036 N525MHFoster Time LLC · Midland, TXBuilt 2019 · S/N 525-1036 N525MMRst Ventures LLC · Franklin, MIBuilt 2013 · S/N 525-0815 N525MSBuilding Specialties Co Of Western Pennsylvania · Saxonburg, PABuilt 2018 · S/N 525-1004 N525MWTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTBuilt 2000 · S/N 525-0370 N525MXAmdel Holding LLC · Houston, TXBuilt 2001 · S/N 525-0423 N525NCF & F Aviation LLC · Memphis, TNBuilt 2018 · S/N 525-0994 N525NVBeers Investment Group Toys LLC · Saint Petersburg, FLBuilt 1994 · S/N 525-0072 N525PGEvo Leasing LLC · Chandler, AZBuilt 2018 · S/N 525-0981 N525PJAdirondack Jets LLC · Scottsdale, AZBuilt 2013 · S/N 525-0809 N525PLRegistered aircraftBuilt 1994 · S/N 525-0043 N525PTR&D Aviation LLC · Florence, ALBuilt 1995 · S/N 525-0125 N525PVBetkor III LLC · Kalispell, MTBuilt 1980 · S/N 501-0188 N525RAJackson Aviation LLC · Dayton, ORS/N 525-0167 N525RCCerovest Capital LLC · Lawrenceville, GABuilt 1997 · S/N 525-0178 N525RDGjjl Equipment LLC · Houston, TXBuilt 1991 · S/N 560-0106 N525RKWest Chester Permit LLC · Cincinnati, OHBuilt 2001 · S/N 525-0413 N525RMBenham James M · College Station, TXBuilt 1997 · S/N 525-0225 N525RPBravo Foxtrot Aviation LLC · Tucker, GABuilt 1993 · S/N 525-0023 N525RRValiair Lc Trustee · Casper, WYBuilt 1997 · S/N E-3069 N525RYBernoulli LLC · Inlet Beach, FLBuilt 2001 · S/N 525-0438

Back to AD 2006-16-18 R1