AD 2011-22-01
Registered aircraft · 1,167
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:2011-22-01')
OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:2011-22-01')
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:2011-22-01') OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:2011-22-01') 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.
N2MGCherokee Aviation LLC · Roseburg, ORN2NBank Of Utah Trustee · Salt Lake City, UTN2PGProcter & Gamble Leasing LLC · Cincinnati, OHN2QEBank Of Utah Trustee · Salt Lake City, UTN2TN2t Inc · Hillsboro, ORN300SCSn 9184 LLC · Fort Lauderdale, FLN302AKTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTN302SBSchell Brothers II LLC · Rehoboth Beach, DEN302TRTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTN303BDFjb 16720 LLC · The Woodlands, TXN305AHNf Air Ventures II LLC · Troy, MIN305LMHga LLC · Dallas, TXN306BDDp Holdings LLC · Davenport, IAN306MASc Aviation LLC · Austin, TXN307MALive Holdings A1 LLC · Windermere, FLN308KGRegistered aircraftN30LSTvpx Trust Co LLC Trustee · North Salt Lake, UTN30SNTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTN310TZFl Jet LLC · Fort Myers, FLN311NBCisco Aero - N9410 LLC · Cisco, TXN312AFBank Of Utah Trustee · Salt Lake City, UTN3131A313 Aviation Holdings LLC · Miami Beach, FLN313BKTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTN313RFWilmington Trust Co Trustee · Wilmington, DEN313RGRenair 650 LLC · New York, NYN314TPTutor Perini Corporation · Sylmar, CAN316FSea To Sea Aviation LLC · Dallas, TXN316GNGeneral Industries LLC · Camden, NJN316VAAvation LLC · Grand Rapids, MIN318LSRegistered aircraftN319CRKangaruby LLC · Wilmington, DEN319FSBanc Of California · Chicago, ILN319GGGg Aviation LLC · San Luis Obispo, CAN319PEPlus3 Aviation LLC · West Hollywood, CAN319STTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTN321SDN321sd Inc · Melbourne, FLN321VCRegistered aircraftN321WAWinchester Air Inc · Winchester, MAN3251KTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTN325APTalaria Logistics LLC · Denver, CON325CBRegistered aircraftN325CTTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTN325HQSunset Harbour Consulting LLC · Miami Beach, FLN3262TTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTN326GXKelgen Partnership Llp · Milwaukee, WIN329SXTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTN33055Maybach Air LLC · Davie, FLN330KCRegistered aircraftN332PMTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTN333DSAdc Holdings LLC · Manteca, CA
Back to AD 2011-22-01