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.
N135KDSkylight Aviation Corp Trustee · Wilmington, DEN135MPDudjak Investments Group LLC · Sugar Land, TXN135RPValiair Lc Trustee · Casper, WYN135SRGunnin Larry · Simpsonville, SCN1360CPinnacle Aviation LLC · Valdosta, GAN1368CCarson Dale Etrustee · Murrieta, CAN136AKGamma2 Inc · San Diego, CAFirst renewal noticeN136HHCirrus Design Corp · Duluth, MNN136RWEquity Estates LLC · Kalispell, MTN1379C79 Charlie LLC · Knoxville, TNN137LUAircraft Guaranty Corp Trustee · Oklahoma City, OKN137PEB & C Aero LLC · San Luis Obispo, CAN137SRForeman Guy W · Valparaiso, INN1382CBerman Aviation LLC · Tulsa, OKN138CKMako Medical Laboratories LLC · Raleigh, NCN138CRValiair Ltd Co Trustee · Casper, WYN138MCCherington Cirrus LLC · Belmont, MAN138MFN138mf LLC · Opa Locka, FLN139CDCirrus Design Corp · Duluth, MNN139JMPegasus Medical Management LLC · Wilmington, DEN139KSpectrum Air LLC · Leesburg, VAN13ANFreedom Okc Aircraft LLC · Oklahoma City, OKN13AUCirrus Design Corp · Duluth, MNN13KHPoppy State Ventures LLC · West Hollywood, CAN13MLM3l LLC · Smyrna, TNN13MYTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTN13PYMartinez De Garcia Linda M · Miami, FLN1403CPinger Kevin · Palo Alto, CAN1408WLate10air LLC · Fullerton, CAN140AFBoard Of Trustees Of Western Michigan University · Battle Creek, MIN140BVGlobal Jetcare Inc · Brooksville, FLN140CDCirrus Design Corp · Duluth, MNN140DKIsland Flight Services LLC · Hauppauge, NYN1416RSkyhawk LLC · Great Falls, VAN141ECDcomm Inc · Austin, TXN141HTBazman Aviation LLC · Harbor Springs, MIN141PGIshikawa Brendon · Davis, CAN1423CGlovis Mark S · Wyandotte, MIN142AKCirrus Design Corp · Duluth, MNN142BKCirrus Sr22 11508 Inc Trustee · Wilmington, DEN142CGlc Equipment Leasing LLC · Paragould, ARN142CWCarbon Wing LLC · Fishers, INN142DCirrus Design Corp · Knoxville, TNN142SFN142sf LLC · Scottsdale, AZN1432CKnoxville Flyers Inc · Knoxville, TNN143CGavin Lauren Aviation LLC · Miami, FLN143CDCirrus Design Corp · Duluth, MNN143SBRegistered aircraftN143TERegistered aircraftN1446CFour Six Chuck LLC · Maynard, MA
Back to AD 2008-14-13