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.
N245TTWotan America Inc · Fort Lauderdale, FLN247EMTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTN252DVG550 Aviation LLC · Grand Rapids, MIN256CWSrit LLC · Irvine, CAN257ATvpx Ars Inc Trustee · North Salt Lake, UTN25CPWilmington Trust Co Trustee · Wilmington, DEN25GVEast Coast Brokerage Services LLC · West Palm Beach, FLN25HLWilmington Trust Company Trustee · Wilmington, DEN25UTTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTN261PWPerryair LLC · New York, NYN267WAGlobal Aircraft LLC · Eden Prairie, MNN269WRWestgate Aviation Giv LLC · Orlando, FLN26RXRxjet Transportation Services Corp · Oxford, CTN272BGFalcon Landing LLC · Hawthorne, CAN273ATisma Holdings Inc · Fairfax, VAN279SHMeneses Enterprises LLC · Houston, TXN279WRTelemachus LLC · New York, NYN27LXTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTN27RARadz Air II LLC · El Segundo, CAN280PHJh III LLC · Roseville, MNN283PHGlobal Services Detroit LLC · Detroit, MIN284PHGlobal Services Detroit LLC · Detroit, MIN285PHGlobal Services Detroit LLC · Detroit, MIN302SBSchell Brothers II LLC · Rehoboth Beach, DEN303BDFjb 16720 LLC · The Woodlands, TXN305AHNf Air Ventures II LLC · Troy, MIN306BDDp Holdings LLC · Davenport, IAN308KGRegistered aircraftN30LSTvpx Trust Co LLC Trustee · North Salt Lake, UTN30SNTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTN310TZFl Jet LLC · Fort Myers, FLN3131A313 Aviation Holdings LLC · Miami Beach, FLN314TPTutor Perini Corporation · Sylmar, CAN316FSea To Sea Aviation LLC · Dallas, TXN316GNGeneral Industries LLC · Camden, NJN316VAAvation LLC · Grand Rapids, MIN319CRKangaruby LLC · Wilmington, DEN319FSBanc Of California · Chicago, ILN319STTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTN321SDN321sd Inc · Melbourne, FLN325CTTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTN325HQSunset Harbour Consulting LLC · Miami Beach, FLN33055Maybach Air LLC · Davie, FLN332PMTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTN333DSAdc Holdings LLC · Manteca, CAN333EHTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTN336EBJ C Flowers & Co LLC · New York, NYN336LSLas Vegas Sands Corp · Las Vegas, NVN337LSLas Vegas Sands Corp · Las Vegas, NVN338LSLas Vegas Sands Corp · Las Vegas, NV
Back to AD 2006-18-13