AD 2012-13-12
Registered aircraft · 1,192
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:2012-13-12')
OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:2012-13-12')
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:2012-13-12') OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:2012-13-12') 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.
N1624K4kla LLC · Pittsfield, MAN1625Saba Rock Transportation LLC · Corona Del Mar, CAN162JCSloan Harry Evans Trustee · Woodland Hills, CAN163JWGo Vector One LLC · Pls Vrds Est, CAN163MDArad Energy LLC · Conroe, TXN166AAE D Santos & Associates LLC Trustee · Wilmington, DEN167ADGrok Air LLC · Miami Beach, FLN167TVTeam Unicorn LLC · Hingham, MAN168CEInternational Aero Services LLC · Bellflower, CAN168PKPmc Global Inc · Sun Valley, CAN169SDBank Of Utah Trustee · Salt Lake City, UTFirst renewal noticeN169TCFlycle LLC · Brecksville, OHN16GJGlobal Empire Trust LLC · Dover, DEN16JNSonance Rocket LLC · San Clemente, CAN16MFRegistered aircraftN171JCAlliance Aviation Group LLC · Wilmington, DEN173NYBlf Aircraft Holdings LLC · Irvine, CAN176MGFlying Orchard LLC · Missoula, MTN176SMBizav Support LLC · Fort Lauderdale, FLN177BBSbg Aircraft Sales And Consulting LLC · Missouri City, TXN178PTPlatinum Aviation LLC · Carson City, NVN1799CTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTN17FJTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTN17KWWcs Inc · Troy, ALN17RXRxjet Transportation Services Corp · Oxford, CTN180CHPointbank · Pilot Point, TXN181PRCgf 1280 LLC · Wilmington, DEN181US181us LLC · Boca Raton, FLN1852VG200 LLC · San Juan, PRN1878EGalaxy Lift LLC · New York, NYN187SGSkybridge Cdl LLC · Scottsdale, AZN188SAAlliance Aviation Group LLC · Wilmington, DEN18BNWorld Rep LLC · Toa Baja, PRN18CJ18cj LLC · Norfolk, VAN18GNNair LLC · Purchase, NYN18HInfinity & Beyond LLC · South Bend, INN18S5531 LLC · Seattle, WAN18TVJax G Enterprises LLC · Scottsdale, AZN1902PTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTN192JERegistered aircraftN192NCScp Aviation LLC · Boca Raton, FLN1932PMozart Investments Inc · Roanoke, VAN1948ZTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTN194MFTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTN1956MRegistered aircraftN1963NWater Force One LLC · Diamond Bar, CAN1964MTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTN1967JEagle Mountain International Church Inc · Newark, TXN196CCPhoenix Nap Management Resources LLC · Phoenix, AZN1979LCabana Air LLC · Frederick, MD
Back to AD 2012-13-12