AD 89-10-11 R1
Registered aircraft · 855
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:89-10-11-R1')
OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:89-10-11-R1')
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:89-10-11-R1') OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:89-10-11-R1') 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.
N34EWPlane Fun Inc Tr Trustee · Snellville, GAN3521TMbm Aviation Consultants Inc · Wilmington, DEN3523TMoreau Robert D · Granbury, TXN3528TR&B Helicopters Inc · Salinas, CAN352MCCitrus County Mosquito Control District · Lecanto, FLN357MCHillsborough County Board Of County Commissioners · Tampa, FLN358HPMoe Dubois Excavating Inc · Shelburne, VTN358RLTopside Aviation Inc · Brasstown, NCN35RPB & B Investments Inc · Yucaipa, CAN365JJtjl Leasing LLC · Cortez, CON368CBAero Leasing LLC · Virden, ILN36MKHorizon Helicopters Inc · Newark, DEN36MQRotor LLC · Dover, DEN376BTAppshle Air LLC · Long Beach, CAN37AJL&R Investment Partners LLC · Wilmington, DEN382CAChem-Air LLC · Shreveport, LAN382SPTag Aviation LLC · Casper, WYN386PZFast Boy Equipment LLC · Houston, TXN3897UCounty Of Cape May · Cape May Ch, NJN3898GWeyerhaeuser Nr Co · Seattle, WAN38HHChemair Helicopters Inc · Jefferson, WIN38MAMinuteman Aviation Inc · Missoula, MTN38NR38nr LLC · Palm Harbor, FLN39049Aspen Helicopters Inc · Oxnard, CAN3906CLindemann Robert A · Holliday, TXN390LHDsl Aviation LLC · Perham, MNN39101Scotts Helicopter Service Inc · Le Sueur, MNN3917GBank Of Utah Trustee · Salt Lake City, UTN391RLMsix Helicopters LLC · Slaughter, LAN392MUsda Forest Service Fepp · Helena, MTN398WCBucks Air Charters Inc · Wilmington, DEN39MKXtreme Aviation LLC · Falkville, ALN3DW T Waggoner Estates · Vernon, TXN3TVMission Air Capital Services L L C · San Antonio, TXN3YJHelicopters Inc · Linden, NJN400UCPacific Rotors Inc · Oceanside, CAN4010GScotts Helicopter Services Inc · Le Sueur, MNN4013GRegistered aircraftN4042GKlein Flying Service Inc · Lawrenceville, ILN4067GDiamond Helicopters LLC · Los Angeles, CAN4068GGulf Coast Helicopters Inc · Pearland, TXN406DBRight Brother Aviation LLC · Chaffee, NYN407ADOcean Air Helicopters Inc · Port Orford, ORN407RVHelicopter Services Of Illinois LLC · Fisher, ILN4088YDumont Associates · Morris Plains, NJN408MRAspen Ag Helicopters Inc · Oxnard, CAN40MCScotts Helicopter Service · Le Sueur, MNN40YBNghiem Daniel DBA · Westminster, CAN411DDHbh Aircraft LLC · Stratford, CTN411KSNorthwest Helicopters LLC · Olympia, WA
Back to AD 89-10-11 R1