AD 2012-01-10
Registered aircraft · 702
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:2012-01-10')
OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:2012-01-10')
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:2012-01-10') OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:2012-01-10') 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.
N8390ADelta Air Lines Inc · Atlanta, GAN83UFTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTN8409NDelta Air Lines Inc · Atlanta, GAN8416BDelta Air Lines Inc · Atlanta, GAN843GSReserve Aircrafts LLC · New York, NYN8458ALogos Aviation Inc · Fort Lauderdale, FLN845ASDodson International Parts Inc · Rantoul, KSN845SASlate Crj Acquisitions 1 LLC · Johnstown, PAN8492CDelta Air Lines Inc · Atlanta, GAN8495BDelta Air Lines Inc · Atlanta, GAN8501FDelta Air Lines Inc · Atlanta, GAN8505QAm Pm Services LLC - Blue Sky Series · Northbrook, ILN8506CAm Pm Services LLC - Blue Sky Series · Northbrook, ILN8515FAm Pm Services LLC - Series One · Northbrook, ILN8516CAm Pm Services LLC- Blue Sky Series · Northbrook, ILN851GKKkh Rentals Inc · San Antonio, TXN8525BAm Pm Services LLC - Blue Sky Series · Northbrook, ILN8532GAm Pm Services LLC- Blue Sky Series · Northbrook, ILN8533DAm Pm Services Llcblue Sky Series · Northbrook, ILN8541DAm Pm Services LLC - Blue Sky Series · Northbrook, ILN854ASSkywest Airlines Inc · St. George, UTN8554AAm Pm Services LLC - Blue Sky Series · Northbrook, ILN855MMMarklyn Jet Parts LLC · Dallas, TXN855RWRepublic Airways Inc · Carmel, INN8560FAm Pm Services LLC - Blue Skies Series · Northbrook, ILN856ASSkywest Airlines Inc · St George, UTN856PPWkair4 LLC · Boerne, TXN8577DAm Pm Services LLC · Northbrook, ILN857RWRepublic Airways Inc · Carmel, INN8580AAm Pm Services LLC - Alpha Series · Northbrook, ILN8587EAm Pm Services LLC - Alpha Series · Northbrook, ILN860RWUmb Bank Na Trustee · Salt Lake City, UTN861RWRepublic Airways Inc · Carmel, INN862RWRepublic Airways Inc · Carmel, INN863RWRepublic Airways Inc · Carmel, INN864RWRepublic Airways Inc · Carmel, INN8665AAm Pm Services LLC - Departure Series · Northbrook, ILN8672AAm Pm Services LLC Departure Series · Northbrook, ILN8694ASlate Crj Acquisitions 1 LLC · Johnstown, PAN871ASFrontera Flight Holdings Inc · Dover, DEN872BCBcc Aviation LLC · Dover, DEN873ASSkywest Airlines Inc · St George, UTN874ASCorporate Flight Management Inc DBA · Smyrna, TNN875ASCorporate Flight Management Inc DBA · Smyrna, TNN876ASSkywest Airlines Inc · St George, UTN877ASSkywest Airlines Inc · St George, UTN877HChallenger 5445 LLC · Allentown, PAN878ASSkywest Airlines Inc · St George, UTN879ASSkywest Airlines Inc · St George, UTN880ASSkywest Airlines Inc · St George, UT
Back to AD 2012-01-10