AD 2014-18-01
Registered aircraft · 5,009
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:2014-18-01')
OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:2014-18-01')
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:2014-18-01') OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:2014-18-01') 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.
N105GPP-1048 LLC · Nashville, TNN105SLSouthwest Aviation Specialties LLC · Tulsa, OKN105TDJcd-Gp LLC · Center, TXN106CJCitation 525 Inc · Eugene, ORN106CKBlt Net Charter Inc · Stamford, CTN106EXChefs Warehouse Transportation LLC · Ridgefield, CTN106JTMountain Air Charter LLC · Dallas, TXN106MJAngstrom Aviation LLC · Southfield, MIN106VPTeam Aero LLC · Shawnee, KSN107GLLeep Enterprises LLC · Mishawaka, INN107JGGrundy Aviation LLC · Horsham, PAN107PTPapa Tango LLC · Petaluma, CAN107RGFalcon 2000ex Msn 157 Leasing LLC · West Harrison, NYN107SLSouthwest Aviation Specialties LLC · Tulsa, OKFirst renewal noticeN1088Fmc Corp · Philadelphia, PAN1088RHampton Railway LLC · Eugene, ORN108BKKent Aviation LLC · Midland, TXN108ELucky Stars LLC · Missoula, MTN108FJBuffalo Valley Ventures Of Tn LLC · Cookeville, TNN108HPTextron Aviation Inc · Wichita, KSN108KJRab Aviation LLC · Tulsa, OKN108LAPrice Services Inc · Monticello, ARN108PHYoung Family Aviation LLC · Sugar Grove, ILN108VRDraughn Aviation LLC · Salado, TXN1099Carolina View Aviation LLC · Greensboro, NCN109APCj2 131 LLC · Milwaukee, WIN109MSCavallino Rampante Inc · Dover, DEN109TWLegacy Jets LLC · Wilmington, DEN10DQTextron Aviation Inc · Wichita, KSN10KJKtkj Challenger LLC · Houston, TXN10LCRegistered aircraftN10MAlset Holding Co LLC · Charlotte, NCN10MDMiss Blackwell Aviation LLC · Pawleys Island, SCN10MMSarma Aviation LLC · Fort Wayne, INN10PFAqua Lift LLC · Key Largo, FLN10PHBlue Sky Harbour LLC · Hummelstown, PAN10QS25p150c LLC · Oklahoma City, OKN10TDPrairie Air LLC · Aberdeen, SDN10TRNtr Aviation LLC · Dallas, TXN10UTOut Aviation LLC · Fort Wayne, INN10XBmd Leasing LLC · Portland, ORN1101AHeritage Aviation Services LLC · Dallas, TXN110ABTbf Group Aviation LLC · Great Neck, NYN110CPPruitt Corp · Leesburg, VAN110DTTillman Self Storage Inc · Wilmington, DEN110EXKm 900 LLC · Chesterfield, MON110FDYellowstone Leasing LLC · Pray, MTN110RFGyansys Equipment LLC · Carmel, INN1111SStockbridge General Contracting Inc · Clovis, CAN111CCWilmington Trust Co Trustee · Wilmington, DE
Back to AD 2014-18-01