AD 63-14-03
Registered aircraft · 9,885
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:63-14-03')
OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:63-14-03')
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:63-14-03') OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:63-14-03') 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.
N1002HSmith Michael S · Anchorage, AKN1004DGiezen Jurgen J · Fairfax, VAN1007UKallam Jerry · Palmer, AKN1008WRay Jonas · Palmer, AKN100AESale Reported · Spencer, NESale reported, pending cancellationN100DDCook Allen J · Aurora, CON100EEConcho Aviation LLC · Sterling City, TXN100JGClub Cherokee Inc · Crystal, MNN100JVKremers Gary · Zeeland, MIN100LGFlyd Pipers Inc · Dyer, INN100LWN100lw LLC · Hickory, NCN100PBDoobie Air LLC · Wilmington, DEN100QBShutt Ryan T · Eden, NYN1012YNelson Susan P · Kirkland, WAN1014BClark Joseph C · Avondale, PAN1014QLawler Thomas O · Lava Hot Springs, IDN1016NDrln Aviation LLC · Charlotte, NCN1018HGulf Air Group Inc · Crestview, FLN1019VQualitair LLC Trustee · MichelstadtN101AFState Of Louisiana · Baton Rouge, LAN101DHLarson David R · Boerne, TXN101DRShaheen Louis · Austin, TXN101DWInternational Air Services Inc Trustee · Carson City, NVN101HHElmhurst Holdings LLC · East Rochester, NYN101NEDarby Flying Corp · Homestead, FLN101NWVortex Aircrafts Inc · Port Saint Lucie, FLN101TVSky Helicopters Inc · Garland, TXN101VBRegistered aircraftN101VRDunn Thomas A · Fairhope, ALN101WCole-Tac LLC · Rapid City, SDN101YTJagt Terrence L · Crestline, CAN1023XBickley David R · Pocatello, IDN1025NGood Aviation LLC · Oshkosh, WIN102AFMjm Enterprises LLC · Wilmington, DEN102CVPilot In Command LLC · Parker, CON102FMRegistered aircraftN102LPWashington State Patrol · Olympia, WAN102MASquaw Creek Aviation LLC · Dover, DEN102MREquipment Services Corp · Wahpeton, NDN1030ZLenhart Thomas E · Barnesville, GAN1033CHuson Lee E · Port Townsend, WAN1036NKovaleski Thomas J · Chugiak, AKN1039PN1039p LLC · Suwanee, GAN103ARHd Outdoor Advs LLC · Coalgate, OKN103ASHill Bryan Thomas · Page, AZN103DJChicoine Chris · Williston, VTN103KCLang Elmer N · Hemphill, TXN103NCState Of North Carolina · Raleigh, NCN103PZRaging Thermal Sky Sports LLC · Brighton, CON103RRLancaster Flyers LLC · Fenwick Island, DE
Back to AD 63-14-03