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.
N6597CHai Services Inc · Haltom City, TXN6599GPremiere Aviation Inc · Concord, CAN659RJFoerstel Edward · Miami Beach, FLN65RPE-Co Aviation LLC · Wilmington, DEN660CABank Of Utah Trustee · Salt Lake City, UTN6614CBg Air Corp · Wilmington, DEN6631CD Porter Enterprises LLC · Dickinson, NDN6633TC C I C Aircraft Division One LLC · Kalispell, MTN663AAHyannis Air Service Inc · Hyannis, MAN6640CGospel Ministries International Inc · Collegedale, TNN664SKenney Michael D · Lucas, TXN6672CBayview Direct LLC · Dover, DEN66CLLiberty Eagle LLC · Helena, MTN675RVb Flying LLC · Cornelius, NCN6765THyannis Air Service Inc · Hyannis, MAN677CAHyannis Air Service Inc · Hyannis, MAN677MFCoastal Resource · Christiansted, VIN67886Hyannis Air Service Inc DBA · Hyannis, MAN678HDawson Aircraft Inc · Clinton, ARN678JGHyannis Air Service Inc DBA · Hyannis, MAN678JSGolden Pegasus LLC · Hughson, CAN67909Hyannis Air Service Inc DBA · Hyannis, MAN6796VBar Wr Air Services LLC · Dallas, TXN6798VGaylord Hangars LLC · Gaylord, MIN6798XSale Reported · WurzburgSale reported, pending cancellationN679JJClement James H Jr · Dallas, TXN67JVNext Gen Aviation LLC · Jenks, OKN67RZModular Aviation LLC · Saratoga Springs, UTN6813JHyannis Air Service Inc DBA · Hyannis, MAN6814RBbc414a LLC · Alton Bay, NHN6815TL A Flyers LLC · Monticello, ARN6817DGlasscock Charles W Jr · Elm Grove, LAN6818XBlue Skys Aero LLC · Vermilion, OHN681RCObsidian Air LLC · Pompano Beach, FLN6822EAir Force One LLC · Coral Springs, FLN6822UKw Aircraft LLC · Judson, TXN6824CK&L Salty Air LLC · Stephenville, TXN682JDWindward Air LLC · Orlando, FLN6834CHigh Performance Aero LLC · Dover, DEN68379Express Carrier LLC · St Thomas, VIN68391Hyannis Air Service Inc DBA · Hyannis, MAN6839YRichland Aviation Inc · Sidney, MTN683TM007 Arkansas Aviation LLC · Jonesboro, ARN6858CSns Air LLC · Billings, MTN685GFAvant Homes LLC · Atlanta, GAN6865ZBarriault Ronald F · Greenville, MEFirst renewal noticeN6866LPoquoy Brook Aviation LLC · North Attleboro, MAN6867F81 Cessna 421 LLC · Ladson, SCN6867LRubin Broadcasting Inc · San Jose, CAN6867ZSonic Bird 1 LLC · Hagerstown, MD
Back to AD 95-09-13