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.
N68685S&S Airplane LLC · Knoxville, TNN6869Z421 Holdings LLC · Zanesville, OHN68752Hyannis Air Service Inc · Hyannis, MAN6875DHyannis Air Service Inc · Hyannis, MAN6879RHyannis Air Service Inc · Hyannis, MAN6882MScuttle421 LLC · Sugar Land, TXN698DRAtm Asset Management LLC · Nashville, TNFirst renewal noticeN699TGTkg Aviation Inc · Port Orange, FLN700FBBocre Leasing Inc · Hauppauge, NYN700HBLucky7 Air LLC · Lenoir, NCN700KBCalifornia Oregon Development LLC · Portland, ORN700LCRent Collector LLC · College Station, TXN7037EHyannis Air Service Inc · Hyannis, MAN706AAArcher Automotive Inc · Houston, TXN706CAHyannis Air Service Inc DBA · Hyannis, MAN706NCGaylord Hangers LLC · Gaylord, MIN7079FTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTN707HATailwinds Aero LLC · Dubuque, IAN707RLApplegate Properties LLC · Morris, ILN707TPRicker David · Conway, ARN711KZPlp Casino Game Development LLC · Leesburg, FLN712JDCpch Aviation LLC · Jacksonville, FLN7135GRegistered aircraftN717BDWeathered Aviation Inc · Rogers, ARN717LRJnnss LLC · Hillsborough, NJN71JRSouthgate Development Inc · Wichita Falls, TXN720FSVero Executive Flyers Inc · Fort Pierce, FLN721HBBrazilco Aviation LLC · Missouri City, TXN723ESEs Owens LLC · Mustang, OKN726RTCrotts Aircraft Service Inc · Dodge City, KSN727ESHoover421 LLC · Rockport, TXN72JAOtter Air LLC · Fishers, INN72KGM & P Aviation LLC · Byhalia, MSN73HMTrn Aviation LLC · Lewes, DEN73TBMagic Leasing LLC · Peotone, ILN740CAHyannis Air Service Inc · Hyannis, MAN744BWDobson'S Leasing Co LLC · Ocoee, FLN744CAMay Richard Ullmann · Soquel, CAN745CARegistration Pending · Dover, DERegistration pendingN747CAAction Air Express Inc · Santa Monica, CAN747WSHyannis Air Service Inc · Hyannis, MAN748CADesert Air Ambulance Inc · Menifee, CAN749CABig Bear Resorts Inc · Big Bear Lake, CAN74PBBaranko Peter A · Meridian, IDN751CAHyannis Air Service Inc · Hyannis, MAN754KCPlane Crazy Aviation LLC · Fargo, NDN755BCMav Management LLC · Rockledge, FLN757RHPanther Partnership Equipment I LLC · Gibsonton, FLN75TTReisback Scott · Olalla, WAN762CACullum Transportation LLC · North Charleston, SC
Back to AD 95-09-13