AD 97-01-05
Registered aircraft · 613
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:97-01-05')
OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:97-01-05')
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:97-01-05') OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:97-01-05') 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.
N40CJInco Investments LLC · San Jose, CAN40JDNup Aviation LLC · Princeton, ILN411VRAirtrust LLC -10-Series 10 Trustee · Sheridan, WYN413ALPlumbfly Aviation LLC · Granbury, TXN414FWIron Steel And Dirt LLC · Fort Wayne, INN414TELaz Air LLC · Hartford, CTN417CWing And A Prayer Inc · Walnut Creek, CAN417FCGreenway Pc-24 LLC · Orlando, FLN417QC P Holdings LLC · Watertown, SDN418KCHastings Steve · Corpus Christi, TXN420CROrange Lightning LLC · Piqua, OHN420EHGk Racing LLC · Derwood, MDN425WHTransportation Services LLC · Huntsville, ALN426EDWindsock Aviation LLC · Bridgeport, WVN428MGSav Aviation LLC · Jacksonville, TXN429MRSmooth Air Leasing LLC · Dubuque, IAN430BTDry Valley Investors LLC · Cleveland, TNN430JFAusome Aviation LLC · Atlanta, GAN432LWBell Avenue Aviation LLC · Des Moines, IAN43NWAirvest Partners LLC · New Bern, NCN440BVBig Sky 205 LLC · Benbrook, TXN443BCTothemoon LLC · Salt Lake City, UTN444CUBtga LLC · Brent, ALN44CKMile High Carpet Rides LLC · Dover, DEN44FJAurora Aircraft LLC · Waterford, MIN44VSHornet Aviation LLC · Anaheim, CAN450CMJonda LLC · Sioux Falls, SDN450TRBc Leasing LLC · Chesterfield, MON454MAMarv Air LLC · Chattanooga, TNN45AFCenturion Air LLC · Draper, UTN469RBDavisair Inc · Lynchburg, VAN46BEOverordered LLC · Jacksonville Beach, FLN471MDCitation Management LLC · Pelham, ALN473DBTrans Air LLC · Helena, MTN475DHDesign Homes Inc · Prairie Du Chien, WIN479CJLima Alpha One LLC · Newark, DEN479MYMcclain Mcclain Mcclain Inc · Ridgeland, MSN47SHGc Aviation Investments LLC · Augusta, ARN481AMRavencrest LLC · Foxboro, MAN484JSouthern Airways LLC · Ridgeland, MSN486CCFlint Transport LLC · Albany, GAN487TTThompson Tractor Co Inc · Birmingham, ALN488SRHard Way LLC · Dover, DEN489CBAir Giant LLC · Watsonville, CAN489HCJ C Cheek Contractors Inc · Kosciusko, MSFirst renewal noticeN48DRRonald L Anderson LLC · Amery, WIN48KFFelder William D · Dallas, TXN490RMDd Sparkplug LLC · Ashtabula, OHN4976HSky Blue Aviation Sales LLC · Bessemer, ALN500SDLord Derby Air LLC · Yukon, OK
Back to AD 97-01-05