AD 74-18-13
Registered aircraft · 1,642
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:74-18-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:74-18-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:74-18-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:74-18-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.
N5351TBie Leasing LLC · Hawkinsville, GAN5362FPetros Michael · Chandler, AZN5371FCummings Todd Bentley · Westfield, NCN5381TBlaes Christopher T · Gallatin, TNN539JBPrince Bruce Alan · Thomasville, NCN54100Pilot Aeromedical Consulting Services LLC · Freeland, MIN542WN542w LLC · Baton Rouge, LAN5431FSea Container Sales Inc · New Waverly, TXN54416Glenn Richard L · York, PAN54417Moore Alan J · Hays, KSN54429Dickinson Robert Trustee · Edmond, OKN54441Lynn David Leander Jr · Reidsville, NCN5487Rhj Investments LLC · Show Low, AZN54KAPoint To Point Air LLC · Arlington, WAN55050Newman Jeffrey M · Pauline, SCN5506JSoaring For Christ LLC · Big Lake, AKN55089Zitren Frederick J · El Cajon, CAN5512JWhitaker Robbie L · Brooklet, GAN55159Rasmussen Paul H · Mitchell, SDN5516JRobarge Andrew Michael · Crown Point, INN5517JGiblin Daniel P · Loveland, OHN5518JEbaugh Michael D · Port Saint Lucie, FLN551AJSo Fine Air LLC · Palm Beach Gardens, FLN55209De Cuir Dennis W · Incline Village, NVN5521JVanrider Jeffrey F · Wildwood, FLN5525JElliott James Richard · Florence, ALN55278Hackman Daniel W · Wimauma, FLN5527JBeachside Transports LLC · Hampstead, NCN55289May Richard J · Fallbrook, CAN5529JFarsighted Aviation LLC · Connersville, INN552JAAv8r Flying Club LLC · Warsaw, INN5530JSellers Justin Kennedy · North Augusta, SCN5532JRegistration Pending · Trinity, FLRegistration pendingN5535JBreadner Robert A · OntarioNon-citizen corporation, flight hours not reportedN55360Ball Duke Allen · Drakesville, IAN5536JHanna Patricia A · Davis Junction, ILN5539JCarr Paul · Ottumwa, IAN5540JLesser Antilles Corp Trustee · Wilmington, DEN5545JMouat Michael Wayne · Hemet, CAN5549JLombardi Steven · Edgewood, TXN5553JHein Investments LLC · Omro, WIN5554JC M Lindsay And Sons Inc · Lumberton, NCN5555JSawyer James K · Odessa, FLN555DLSchaben Justin · Dunlap, IAN555JLSearles Warren Jr F · Pittstown, NJN5560JSanilac Air LLC · Applegate, MIN55629Mccarthy Robert · Farmers Branch, TXN5565JPerez Luis M Trustee · Corona, CAN5566JBickwall Aviation LLC · Wilmington, DEN55679Patriot Parachute Team Inc · Blaine, MN
Back to AD 74-18-13