AD 95-09-13
Registered aircraft · 1,061
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:95-09-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:95-09-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:95-09-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:95-09-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.
N414BGGreen Forest Aviation LLC · Edmond, OKN414BLBig South Fork Aero Inc · Huntsville, TNN414BPN414bp LLC · Valley Center, KSN414BRQualitair LLC Trustee · MichelstadtN414BSHunger Relief Ministries · Forney, TXN414BTCmo Blue Sky LLC · Tomball, TXN414BWSky West Aviation Inc Trustee · Albuquerque, NMN414CASurgeon LLC · Arcadia, LAN414CLL Squared Aviation LLC · Marine, ILN414CMMartin Livestock LLC · Ione, CAN414CNAllied Asset Management LLC · Oklahoma City, OKN414CSCareflight Logistics LLC · Bingham Farms, MIN414CWCrosswind Media LLC · Terrell, TXN414DDModern Custom Design LLC · Melbourne Beach, FLN414DSGable S Corp · West Linn, ORN414DWAgrigro Midwest Aviation LLC · Poplar Bluff, MON414EESp Aviation Inc · Hayward, CAN414EGHardrock Transport LLC · Pulaski, VAN414EHSurdex Corp · Chesterfield, MON414FBMk414 LLC · Fredericksburg, TXN414FCTaff Logistics LLC · Gilmer, TXN414FGGrisham Charlie · Odessa, TXN414GAN732tc LLC · Roswell, GAN414GBHeritage Rotors LLC · De Leon Springs, FLN414GDBww And Associates LLC · Ocala, FLN414GGHangar 21 Aviation LLC · Shreveport, LAN414GPSs Aviation LLC · Sulphur, LAN414GRHuron Mountain LLC · Grand Rapids, MIFirst renewal noticeN414HBRaj Leasing Mt LLC · Missoula, MTN414HKBdi Air Inc · Bakersfield, CAN414HLWarwick Corp · Laughlin, NVN414HMHf&P Holdings LLC · Helena, MTN414JAGhanbarzadeh Jamshid · Costa Mesa, CAN414JFJuliet Fox LLC · Saint Augustine, FLN414JLDodson International Parts Inc · Rantoul, KSN414JMLangenstein Richard J · Houston, TXN414JZAcv Group LLC · Mckinleyville, CAN414KSky Magic Aviation Inc Trustee · Wilmington, DEN414KSSmi Air LLC · Key West, FLN414KWBolle Aviation LLC · Clare, MIN414LACapay Capital Advisors Inc · Woodland, CAN414LCMeade Lance · Stinson Beach, CAN414LLAb Monterrey Aircraft LLC - Trustee · San Antonio, TXN414LMFawnbrook Aviation LLC · Glendora, CAN414LPPhillips Michael Lance · Plano, TXN414MADlk Aviation Corp · Waukesha, WIN414MCLonghorn Aviation LLC · Missoula, MTN414MDRaptor 414 Airmotive LLC · Poplar Grove, ILN414MHAmerican Capital Aviation LLC · Alpine, WYN414MJTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UT
Back to AD 95-09-13