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.
N123CGLmadif LLC · Kaukauna, WIN123DVInternational Air Services Inc Trustee · Carson City, NVN123ETMike Charlie Inc · Lewes, DEN123HBValiair Limited Co Trustee · Casper, WYN123VGCrepco LLC · Benton, ARN123XCEiger Aviation LLC · Woodstock, ILN123ZMAircraft Solutions LLC · Spokane, WAN1249CDane Aviators LLC · Waunakee, WIN124CRAero-Mobil Inc · Wilmington, DEN124ECSpry Logistics LLC · Ponchatoula, LAN124JFRegistered aircraftN124JWCloud Aviation LLC · Ooltewah, TNN124KWN124kw Corp Trustee · Wilmington, DEN124MBToad Hall Management LLC · Greenwich, CTN124RRFloralyn Aviation LLC · West Palm Beach, FLN124SFCirrus Design Corp · Knoxville, TNN124SPMinnesota State Patrol · Saint Paul, MNN124TBCpaviation LLC · Holt, MIN124VBEagle Rentals LLC · Alhambra, CAN124VLMessick Jody · Chesterfield, VAN1256Towner Jason A · Burneyville, OKN125BRRh22 LLC · Tampa, FLN125CAFabre And Co LLC · Baton Rouge, LAN125FDJ Gonzales Properties LLC · Prairieville, LAN125LCStrike Fund LLC · Peachtree City, GAN125SFCovino John M · Ashland, MAN125VVolar IV LLC · Edmond, OKN1265CDbg Aviation · Roscoe, ILN1268CKnight Russell P · East Greenwich, RIN126ABOxford Systems Inc · Hicksville, NYN126CDCirrus Design Corp · Duluth, MNN126GEGot Wings LLC · Woodbury, NYN12747Six Bravo Period LLC · Miami, FLN127CDRegistered aircraftN127DCMountain Aviation LLC · Crossville, TNN127SKVoyager Exploration Inc · Marblehead, OHN1281Cirrusazflmi LLC · Midland, MIN1281FPantheon Aviation LLC · Franklin, NCN1284CCirrus N1284c LLC · Oakland Park, FLN1287C907th Flight Squadron Inc · Wilmington, DEN128BVAbel Donald B · Greenville, WIN128CDMetamorphosis Publishing LLC · Hamilton, MTN128CWTres Ninos LLC · Dover, DEN128FAWe So Fly LLC · Edgemoor, SCN128FTN128ft LLC · Erie, CON128JFFloyd Stephen M · Spotsylvania, VAN128PFSky West Aviation Inc Trustee · Albuquerque, NMN128REHotel Juliet Romeo Echo LLC · Crosby, TXN128VVolar Vi LLC · Edmond, OKN128WCAgdj Holdings LLC · Brookshire, TX
Back to AD 2008-14-13