Skip to content

Registered aircraft · 532

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:2003-03-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:2003-03-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:2003-03-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:2003-03-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:2003-03-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:2003-03-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.

N264VRTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTBuilt 2002 · S/N 560-5264 N269CRContinental Resources Inc · Baker, MTBuilt 2026 · S/N 560-6509 N271SBVillains Airways LLC · Newark, DEBuilt 2000 · S/N 550-0940 N278XL560xl LLC · Newark, DEBuilt 2002 · S/N 560-5278 N286VRTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTBuilt 2002 · S/N 560-5286 N288HLJbm Equipment Leasing LLC · Center, TXBuilt 2002 · S/N 560-0599 N291DVFall River Aviation LLC · Corvallis, ORBuilt 2001 · S/N 560-5146 N296VRTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTBuilt 2002 · S/N 560-5296 N299RKGasser LLC · Midland, TXBuilt 2002 · S/N 550-1027 N29QAWar Horse Aviation LLC · Whitsett, TXBuilt 2002 · S/N 560-5277 N2KK2872 Holdings LLC · Burleson, TXBuilt 2003 · S/N 560-5319 N301VRTonglen LLC · Farmingdale, NYBuilt 2002 · S/N 560-5301 N303CPDjh1 LLC · Liberty Township, OHBuilt 2000 · S/N 560-0539 N304MRMirric Entertainment LLC · Pittsburgh, PABuilt 1999 · S/N 560-5033 N30EKHw Consulting LLC · Reno, NVBuilt 2004 · S/N 560-5369 N310FXFlexjet LLC · Cleveland, OHBuilt 2016 · S/N 50500366 N3116BIntegrity Air LLC · Jefferson, TXBuilt 2002 · S/N 560-0625 N314CWR & B Aviation LLC · Columbia, MOBuilt 2025 · S/N 560-6504 N318GLFamily Air LLC · Louisville, KYBuilt 2003 · S/N 550-1060 N318MMPerfect Agreement Leasing Inc · Trabuco Canyon, CABuilt 2001 · S/N 560-5220 N321CLVolatus Aviation Holdings LLC · Houston, TXBuilt 2004 · S/N 560-5527 N325NDN325nd LLC · Wilmington, DEBuilt 2002 · S/N 560-5284 N327MMMoose Aviation LLC · Wilmington, DEBuilt 2001 · S/N 560-5149 N330GCOia Air Corp · Nashua, NHBuilt 2005 · S/N 560-5501 N335RJWings II LLC · Birmingham, ALBuilt 2003 · S/N 550-1063 N336RJSix Star Inc · Winter Park, FLBuilt 2004 · S/N 560-5365 N336XLCompassco LLC · Dallas, TXBuilt 2003 · S/N 560-5336 N33PXAirtime LLC · Mont Belvieu, TXBuilt 2002 · S/N 560-0614 N342BLChandler (U S A) Inc · Chandler, OKBuilt 2003 · S/N 5605342 N346XLRolling Green Enterprises LLC · St Louis Park, MNBuilt 2003 · S/N 560-5346 N357BERegistered aircraftBuilt 2004 · S/N 560-0663 N357MJJavier'S Group LLC · Aliso Viejo, CABuilt 1999 · S/N 560-5026 N3616Carter Machinery Co Inc · Salem, VABuilt 2001 · S/N 560-0571 N362GHQuality Leasing Inc · Niceville, FLBuilt 2004 · S/N 560-5362 N363CAAlpha Mike Aviation LLC · Murfreesboro, TNBuilt 2002 · S/N 550-1009 N368HSTaylor Aviation LLC · Virginia Beach, VABuilt 1999 · S/N 550-0889 N36CPTitan Aviation LLC · Wilmington, DEBuilt 2004 · S/N 5600654 N3750NNelson Family Holdings LLC · Wisconsin Dells, WIBuilt 2004 · S/N 560-5534 N379ECRebus II LLC · Owasso, OKBuilt 2003 · S/N 560-0642 N384SHSilverhawk Aviation Inc · Lincoln, NES/N 560-5309 N385SHH & H Automotive LLC · Omaha, NEBuilt 2005 · S/N 560-5590 N386SHVip Tanks LLC · La Vista, NEBuilt 2000 · S/N 560-5119 N395WJRim 3 Group LLC · Waterford, MIBuilt 2003 · S/N 560-5330 N397BCBest Air Inc · Ferdinand, INBuilt 2002 · S/N 560-5291 N398PFP F D Supply Corp · Edwardsville, ILBuilt 2026 · S/N 560-6505 N398RSJpq1 LLC · Tonka Bay, MNS/N 560-5009 N39RCRich Plane LLC · Gilberton, PABuilt 1999 · S/N 5605041 N4000KTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTBuilt 2000 · S/N 560-5081 N4031B40thirty1 Aviation LLC · Panama City Beach, FLBuilt 2001 · S/N 550-0985 N411KQSolid Axle Management II LLC · Marshall, TXBuilt 2002 · S/N 560-5226

Back to AD 2003-03-21