AD 2018-04-13
Registered aircraft · 1,373
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:2018-04-13')
OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:2018-04-13')
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:2018-04-13') OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:2018-04-13') 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.
N673PPRegistered aircraftN674EFEdinton Holdings USA Inc · Miami, FLN675LCRockies West LLC · Eugene, ORN680WAWonderful Orchards LLC · Bakersfield, CAN682EEPraetor Ssi LLC · Lighthouse Point, FLN685ARBua Delaware Inc · Wilmington, DEN686BERegistered aircraftN686CBTvpx Ars Inc Trustee · North Salt Lake, UTN686CGRegistered aircraftN6872Sage Moon Air LLC · Salt Lake City, UTN695BAFlying Strategies LLC · Garland, TXN696HCRegistered aircraftN696HQRegistered aircraftN697CCRegistered aircraftN699PBSuperior Products 2 LLC · South Plainfield, NJN699SCRegistered aircraftN69AFTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTN700BCTvpx Trust Co LLC Trustee · North Salt Lake, UTN700RHRite Direction Corp · Milwaukee, WIN7011MTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTN701QSRegistered aircraftN702QSRegistered aircraftN702RWEcl Leasing LLC · Las Vegas, NVN703DSJd Stauffer LLC · Nokomis, FLN703QSRegistered aircraftN704JBJimmie Johnson Racing II Inc · Birmingham, MIN704LBRhcp 280 LLC · West Chicago, ILN705QSRegistered aircraftN706QSRegistered aircraftN707KGBbhco LLC · Los Angeles, CAN707MHDrg Challenge LLC · Sonoma, CAN707QSNetjets Sales Inc · Oklahoma City, OKN707SCS Cole Aviation LLC · Midland, TXN707SGTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTN708QCindago LLC · Rancho Cucamonga, CAN708QSRegistered aircraftN709QSBarnhart Interests Inc · Oklahoma City, OKN70CRWorld Wing Sales LLC · Pearland, TXN70RLBs Aviation Holdings II LLC · Englewood, CON710BAContrail Aviation LLC · Philadelphia, PAN710ECChouest Air Inc · Galliano, LAN710QSAir To Land LLC · Oklahoma City, OKN711HAHoyt Air Inc · Phoenix, AZN711QSCiena Corp · Oklahoma City, OKN712AQRrp Aviation LLC · Dover, DEN712BHProject Finance Inc · Ada, MIN712WBBlessey Aviation LLC · Big Sky, MTN713BLBmb Aircraft LLC · Oklahoma City, OKN713DHHigginbotham Management Co Inc · New Smyrna Beach, FLN713SSDream Catcher 2020 LLC · East Helena, MT
Back to AD 2018-04-13