AD 2006-18-13
Registered aircraft · 572
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:2006-18-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:2006-18-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:2006-18-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:2006-18-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.
N554SNTvpx Trust Co LLC Trustee · North Salt Lake, UTN555KHRegian Services LLC · Encino, CAN5569Landmark Graphics Corp · Houston, TXN5585Tvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTN559DWTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTN559GGlen Alba Investments Inc Trustee · Wilmington, DEN55BMJet Force V LLC · Fresno, CAN55FVIsh Flight LLC · Bloomfield Hills, MIN55GVTc Business Aviation LLC · San Francisco, CAN55QCQuikrete Aircraft Leasing LLC · Atlanta, GAN5616Geev LLC · Cartersville, GAN561SKJet Air Management LLC · Miami Beach, FLN563BBGulfstream V 563 LLC · Midland, TXN563CBCb Aviation Inc · Ogden, UTN565JCBank Of Utah Trustee · Salt Lake City, UTN565JMNational Oceanic And Atomospheric Administration · Lakeland, FLN565JTBank Of Utah Trustee · Salt Lake City, UTN566PGC2d LLC · Wilmington, DEN568GAGulfstream Aerospace Corp · Savannah, GAN568JLTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTN56BUBsi Holdings LLC · Portland, ORN56CAusome Aviation LLC · Newark, DEN581DWilmington Trust Co Trustee · Wilmington, DEN582DWeidner Property Management LLC · Kirkland, WAN585DSt Con Aviation LLC · Nashville, TNN585DWColleen Corp · New Castle, DEN585JCTvpx Ars Inc Trustee · North Salt Lake, UTN586GDGulfstream Aerospace Corp · Savannah, GAN587GDGulfstream Aerospace Corp · Savannah, GAN588ATTannjets Aerospace I LLC · Miami, FLN588DZGrowth Holdings LLC · Broken Arrow, OKN588GGulfstream Aerospace Corporation · Savannah, GAN588PXBank Of Utah Trustee · Salt Lake City, UTN588TNTannjets Aerospace II LLC · Fort Lauderdale, FLN591BCInternational Bank Of Commerce · Laredo, TXN595EXTiny Bronco LLC · Newark, DEN599HRegistered aircraftN599HGSunshine Sky Aviation LLC · Doral, FLN599TRTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTN59JEIn59je LLC · New York, NYN5BLBlm Aviation LLC · Dover, DEN5PDMid-Atlantic Aviation III LLC · Saint Petersburg, FLN5SNDodson International Parts Inc · Rantoul, KSN600WGWeldon Granger J · Houston, TXN603BGTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTN603JRTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTN608CLCassandra Lee Flight Operations LLC · Las Vegas, NVN60PASun Meridian Riverside LLC · Brea, CAN611JMJfm Inc · Oak Brook, ILN612MJTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UT
Back to AD 2006-18-13