AD 2000-03-03 R1
Registered aircraft · 781
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
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:2000-03-03-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:2000-03-03-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:2000-03-03-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:2000-03-03-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.
N527GJUnited Airlines Inc · Chicago, ILN527JAFg&N Plane Partners LLC · Kalamazoo, MIN528GJUnited Airlines Inc · Chicago, ILN530GJSkywest Airlines Inc · Saint George, UTN530JWBank Of Utah Trustee · Salt Lake City, UTN532GJSkywest Airlines Inc · Saint George, UTN541PJPearlmaster Aviation Inc · Hinsdale, ILN546DHRdh Air LLC · Omaha, NEN5481TRegistration Pending · Allentown, PARegistration pendingN548DDModa Aviation LLC · Woodbury, NYN54JCTuck Aviation LLC · Tucson, AZN555DFKing Leo Management LLC · Beverly Hills, CAN558GJSky West Airlines Inc · Saint George, UTN55HFHfp LLC · Rogers, ARN561GJUnited Airlines Inc · Chicago, ILN563WJExpress Transportation Corp · Cheyenne, WYN579RSFrancis Victor LLC · Dallas, TXN580KRTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTN581GJUnited Airlines Inc · Chicago, ILN584GJUnited Airlines Inc · Chicago, ILN5GGfo Aviation LLC · Dallas, TXN600GA601 Holdings LLC · Las Vegas, NVN601BEReserve Aircrafts LLC · New York, NYN601HGug LLC · Wilmington, DEN601HWO Plus A Aviation LLC · Rockwall, TXN601JGChallenger Aircraft Charters LLC · Newport Beach, CAN601JPLove Aviation LLC · Dallas, TXN601QAQuality Aircraft Sales Inc · Boca Raton, FLN601TPPyle Group LLC · Madison, WIN601VRN560bl LLC · Orlando, FLN604AUBank Of Utah Trustee · Salt Lake City, UTN604AVAero Ventures 5 LLC · Torrington, CTN604BBMa Aviation LLC · Fargo, NDN604BCWpc Holdings LLC · Fort Lauderdale, FLN604CRUS Auto Finance Leasing LLC · Wilmington, DEN604DTTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTN604EMRegistered aircraftN604FMBlue Five LLC · Omaha, NEN604GFTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTN604GWCfc LLC · Bloomington, INN604HMHarbert Aviation LLC · Birmingham, ALN604HSHsl II LLC · Tampa, FLN604KJNew Kpc Holdco LLC · Fort Lauderdale, FLN604LASwallow Acquisitions LLC · Wilmington, DEN604MN604m LLC · Scottsdale, AZN604MBChallenger 601 Holdings LLC · Missoula, MTN604MHRegistered aircraftN604MTDodson International Parts Inc · Rantoul, KSN604PSBank Of Utah Trustee · Salt Lake City, UTN604PVStallion Aviation II LLC · Roseland, NJ
Back to AD 2000-03-03 R1