AD 2008-14-13
Registered aircraft · 5,659
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:2008-14-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:2008-14-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:2008-14-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:2008-14-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.
N151SRBas Part Sales LLC · Greeley, CON1527CSp Air LLC · Birmingham, IAN152CDPlane Crazy LLC · Bay Minette, ALN152SBPegasus Aviation Partners LLC · Little Rock, ARN152SDSt Regis Air LLC · Lancaster, PAN152SRLangan Adam · Norfolk, NEN152TCJeckair LLC · Soddy Daisy, TNN152WKCrotty Daniel J Jr · Richmond, RIN1531CRamos Aircraft Leasing LLC · Lagrange, OHN1539CMarincus Benjamin Marius · Medford, ORN153BWRegistered aircraftN153CDInternational Air Services Inc Trustee · Carson City, NVN153CKBrosche David S · Jacksonville, FLN153EQualitair LLC Trustee · MichelstadtN153JSGg Air LLC · Gainesville, GAN153SRAircraft Guaranty Corp Trustee · Oklahoma City, OKN1540CBank Of Utah Trustee · Salt Lake City, UTN1547CGraff Oliver E · Long Beach, CAN1549HHudson Aviation LLC · Charlotte, NCN154CSGlass Cockpit Aviation LLC · N Massapequa, NYN154JNMatos Holdings Corp · Weston, FLN154LSSindhu Azhar · Humble, TXN154SSand Building LLC · Fuquay Varina, NCN154SDWarnes Thomas S · Tampa, FLN154WFBoard Of Trustees Of Western Michigan University · Battle Creek, MIN155AJEuroaviation Inc Trustee · KematenN155CDVillines Dustin · Lincoln, ARN155HRAircraft Guaranty Corp Trustee · Oklahoma City, OKN155SRSmedley Charles A · Medford, ORN155THEs Aviation LLC · Memphis, TNN156CDJetstream Enterprises LLC · Portland, ORN156CSBoard Of Trustees Of Western Michigan University · Battle Creek, MIN156KTFrench River Group Aero LLC · Jasper, GAN1570CMottern Edward Thomas · Greenwood, SCN157ATJasper Dane · Santa Rosa, CAN157CDSierra Sky Aviation LLC · Carson City, NVN157ESCirrus Sr22 4386 Inc · Wilmington, DEN157JHHendren Aviation LLC · Gravette, ARN157SRWildcat Aviation LLC · South Beach, ORN157TXHlebichuk David D · Montgomery, TXN157VRoco Air LLC · San Antonio, TXN158BJbc Holdings LLC · Yarmouth, MEN158CDWingsleasing LLC · Wichita, KSN159CDN159cd LLC · Buford, GAN159CSBank Of Utah Trustee · Salt Lake City, UTN159HAHotel Alpha II LLC · Chattanooga, TNN159PGAscent Aviation Inc · Duluth, MNN159SRDehbozorgi Amir · Irvine, CAN15BMTapcor Aviation LLC · Riverside, CAN15CXKlausman Branin W · Mascoutah, IL
Back to AD 2008-14-13