AD 2006-04-13
Registered aircraft · 670
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-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:2006-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:2006-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:2006-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.
N555KHRegian Services LLC · Encino, CAN5569Landmark Graphics Corp · Houston, TXN5585Tvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTN558APLmc Leasing LLC · Tallahassee, FLN559DWTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTN559GGlen Alba Investments Inc Trustee · Wilmington, DEN55QCQuikrete Aircraft Leasing LLC · Atlanta, GAN561SKJet Air Management LLC · Miami Beach, FLN565JMNational Oceanic And Atomospheric Administration · Lakeland, FLN568GAGulfstream 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, WAN584AAramco Associated Co · Houston, TXN585DWColleen Corp · New Castle, DEN586GDGulfstream Aerospace Corp · Savannah, GAN587DVFs Leasing LLC · Newark, DEN587GDGulfstream Aerospace Corp · Savannah, GAN588DZGrowth Holdings LLC · Broken Arrow, OKN588GGulfstream Aerospace Corporation · Savannah, GAN588PXBank Of Utah Trustee · Salt Lake City, UTN588TNTannjets Aerospace II LLC · Fort Lauderdale, FLN58AJSe Sfj LLC · Great Neck, NYN592FCJuno Aviation LLC · Juno Beach, FLN595EXTiny Bronco LLC · Newark, DEN599HRegistered aircraftN59APComputer Sciences Corp · Tysons, VAN59CFTailwind Holdings LLC · San Ramon, CAN5BLBlm Aviation LLC · Dover, DEN5PDMid-Atlantic Aviation III LLC · Saint Petersburg, FLN5SNDodson International Parts Inc · Rantoul, KSN603BGTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTN603JRTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTN607DDominion Energy Services Inc · Richmond, VAN608CLCassandra Lee Flight Operations LLC · Las Vegas, NVN609EZYates Aviation LLC · Texarkana, TXN609STWilmington Trust Co Trustee · Wilmington, DEN611JETvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTN611JMJfm Inc · Oak Brook, ILN612AFAmeriprise Financial Inc · Oxford, CTN612MJTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTN613AQTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTN615TT17 South Briar Hollow Lane LLC · Brookshire, TXN616AFAmeriprise Financial Inc · Oxford, CTN616CAPioneer Hi-Bred International Inc · Wilmington, DEN616RKBank Of Utah Trustee · Salt Lake City, UTN620JHBank Of Utah Trustee · Salt Lake City, UTN622GKAircraft Holding Solutions LLC Trustee · Newark, DE
Back to AD 2006-04-13