Registered aircraft · 90

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:2008-09-21') OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:2008-09-21') 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:2008-09-21')
    OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:2008-09-21')
  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:2008-09-21')
  OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:2008-09-21')
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.

N108BKKent Aviation LLC · Midland, TXBuilt 2001 · S/N 305 N134CJSkyview LLC · Wilmington, DES/N 134 N136MVTransnet Aviation Group LLC · Short Hills, NJBuilt 2001 · S/N 311 N150RJ513 LLC · Newark, DEBuilt 2002 · S/N 324 N191NMcm Leasing LLC · Pittsfield, MABuilt 2003 · S/N 334 N200GXTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTBuilt 2004 · S/N 336 N200WLTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTBuilt 2007 · S/N 352 N203NCC Aviation LLC · Maiden, NCBuilt 1990 · S/N 203 N214DVRk-492 Leasing LLC · Miami, FLBuilt 2007 · S/N 350 N214FTTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTBuilt 2000 · S/N 300 N221CBFalcon 50ex 320 LLC · Miami Gardens, FLBuilt 2001 · S/N 320 N23FMTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTBuilt 2000 · S/N 296 N264RVHfa Specialty Acquisitions LLC · Boca Raton, FLBuilt 2002 · S/N 327 N280BDLcg Enterprises LLC · Greenwich, CTBuilt 2003 · S/N 332 N291BBattelle Memorial Institute · Columbus, OHBuilt 2001 · S/N 317 N299PRMeregrass Inc · Dublin, TXBuilt 2000 · S/N 299 N29BBattelle Memorial Institute · Columbus, OHBuilt 2005 · S/N 343 N311BPWls Enterprise LLC · Portland, ORBuilt 2001 · S/N 314 N313PJRpc Aviation LLC · Fayetteville, ARBuilt 2000 · S/N 302 N315EXTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTBuilt 2001 · S/N 315 N315SCInternational Skychase Corp · Alachua, FLBuilt 1982 · S/N 130 N319CFOcean Drive Bulgaria Corp · Wilmington, DEBuilt 2001 · S/N 319 N325EXFalcon 325 LLC · Fort Pierce, FLBuilt 2002 · S/N 325 N346EXWebair LLC · Warrenton, VAS/N 346 N373RRM10 LLC · Rolling Meadows, ILBuilt 1997 · S/N 259 N37WXCsc Delaware Trust Co Trustee · Wilmington, DEBuilt 2000 · S/N 309 N383MCTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTBuilt 2002 · S/N 322 N388BBPw Transport LLC · Lafayette, LABuilt 1999 · S/N 281 N395HEBillron LLC · Houston, TXBuilt 1992 · S/N 228 N396JR396jr LLC · Macon, GABuilt 2005 · S/N 341 N408CJDt Management Group LLC · Phoenix, AZBuilt 2000 · S/N 293 N413VLFalcon Vl LLC · Wilmington, DEBuilt 2006 · S/N 345 N500CFPool Plane LLC · Seattle, WABuilt 2000 · S/N 303 N500LY1380 Jets LLC · Pittsfield, MABuilt 2002 · S/N 323 N50BLBnb LLC · Wilmington, DES/N 2 N50FGRegenerative Sports Tissue Bank Inc · Lawrenceville, GABuilt 1988 · S/N 187 N50PCSpritle LLC · Chicago, ILBuilt 2000 · S/N 308 N50SNFirst Quality Falcon LLC · Great Neck, NYBuilt 2000 · S/N 310 N50YPVillages Equipment Co · Leesburg, FLBuilt 2005 · S/N 344 N50YTInternational Aviation Technical Services Inc · Torrance, CABuilt 1996 · S/N 269 N510MPPark Avenue Aircraft Trust LLC Trustee · Dover, DEBuilt 1984 · S/N 140 N5123Tpi Aircraft Interiors LLC · New Bern, NCBuilt 1984 · S/N 123 N513SKHappy Skies LLC · Dover, DEBuilt 2004 · S/N 338 N516CJTotal Aviation Corp · Garden City, NYBuilt 1980 · S/N 016 N522EECenergistic LLC · Dallas, TXBuilt 1999 · S/N 282 N54YPPhifer Inc · Tuscaloosa, ALBuilt 2003 · S/N 333 N550WMWno Trust Services LLC Trustee · Wilmington, DEBuilt 1992 · S/N 229 N556HDN50hd LLC · Salt Lake City, UTBuilt 2002 · S/N 321 N55HSRapid Leasing Inc · Cedar Rapids, IABuilt 1998 · S/N 276 N58HLGreen Button Holdings LLC · Overland Park, KSBuilt 1999 · S/N 279

Back to AD 2008-09-21