AD 2017-26-05
Registered aircraft · 679
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:2017-26-05')
OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:2017-26-05')
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:2017-26-05') OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:2017-26-05') 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.
N14ADynamic Avlease Inc · Bridgewater, VAN151JETvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTN151SDAviation Company Inc · Cheyenne, WYN154CRed River Aircraft Leasing LLC · Anchorage, AKN154FVGenav 3 LLC · Miami, FLN154GGlf4 1044 LLC · Fort Lauderdale, FLN156AMMontana Aircraft Trust Inc Trustee · Bozeman, MTN156WJ156wj LLC · Farmingdale, NYN15YApa Stream LLC · New York, NYN160LDRegistered aircraftN161MMRye & Olive LLC · Naples, FLN1624K4kla LLC · Pittsfield, MAN1625Saba Rock Transportation LLC · Corona Del Mar, CAN163JWGo Vector One LLC · Pls Vrds Est, CAN163MDArad Energy LLC · Conroe, TXN163PAN163pa LLC · Wilmington, DEN167ADGrok Air LLC · Miami Beach, FLN169TCFlycle LLC · Brecksville, OHN16GJGlobal Empire Trust LLC · Dover, DEN16JNSonance Rocket LLC · San Clemente, CAN171JCAlliance Aviation Group LLC · Wilmington, DEN173PAN173pa LLC · Wilmington, DEN175BGMile High Holdings LLC · Miami, FLN176MGFlying Orchard LLC · Missoula, MTN177BBSbg Aircraft Sales And Consulting LLC · Missouri City, TXN178PTPlatinum Aviation LLC · Carson City, NVN17KWWcs Inc · Troy, ALN17LKAircraft Holding Solutions LLC Trustee · Newark, DEN180CHPointbank · Pilot Point, TXN181PRCgf 1280 LLC · Wilmington, DEN181US181us LLC · Boca Raton, FLN183PASandy Wings LLC · Wilmington, DEN184PABartowjets LLC · Wilmington, DEN187SGSkybridge Cdl LLC · Scottsdale, AZN188SAAlliance Aviation Group LLC · Wilmington, DEN18TVJax G Enterprises LLC · Scottsdale, AZN1902PTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTN190PASandy Wings LLC · Wilmington, DEN192JERegistered aircraftN192NCScp Aviation LLC · Boca Raton, FLN195PASandy Wings LLC · Wilmington, DEN1963NWater Force One LLC · Diamond Bar, CAN196CCPhoenix Nap Management Resources LLC · Phoenix, AZN196PASandy Wings LLC · Wilmington, DEN1979LCabana Air LLC · Frederick, MDN197BDAfc Management LLC · Englewood, NJN1986RRts Administrative Service Inc · Overland Park, KSN198GSTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTN198PABartowjets LLC · Wilmington, DEN1BGGlobal Empire Trust LLC · Dover, DE
Back to AD 2017-26-05