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.
N213PDDrb Helicopters LLC · Klamath Falls, ORN21470Southwest Heliservices LLC · Mesa, AZN21507Steuben Foods Inc · Elma, NYN2155ZHeli Incorporated · Las Vegas, NVN217HKHolden Thomas J · Warrington, PAN217JSOceanside Vertical Express LLC · Canaan, NYN2183YRegistered aircraftN2187LRanger Aviation Leasing LLC · Wilmington, DEN2192Flyers Enterprises Inc · Alpine, CAN2193XIndustrial Helicopters LLC · Lafayette, LAN2196JIron Horse Cub LLC · Arlington, TXN219SHRegistered aircraftN21MRMacy Robert S · Post, TXN21MWAir Flite Inc · Shawnee, OKN21RTL&R Investment Partners LLC · Wilmington, DEN220GPRotorheads Leasing LLC · Perham, MNN220SASpurger Aviation LLC · Spurger, TXN221GPChemair Helicopters Inc · Jefferson, WIN222HAJasons Helicopter Services · New Prague, MNN2239WBodner Jessica Kay · Emigrant, MTN224EESutton James Donald · Turkey, NCN224KMStatzel Steve DBA · New Haven, MON225PDBaton Rouge Police Department · Baton Rouge, LAN2268GCrm Investments Inc · Wilmington, NCN2268WChorman Spraying LLC · Milton, DEN2268XLinscott Jeffrey R · Boring, ORN226WANewton Property Leasing LLC · Greene, IAN22743Applebee Aviation Inc · Banks, ORN2274WDiaz Mark A DBA · Modera, CAN2275QSierra Bravo Aviation Inc · San Francisco, CAN2277AMountain Helicopters LLC · Salt Lake City, UTN227VTTag Aviation LLC · Casper, WYN22823Steve Wright Enterprises Inc · Alpine, CAN2295FNorgrain Helicopters LLC · Hattiesburg, MSN2297EWestwind Helicopters Inc · Santa Fe, TXN2299UCb Couch Inc · Walcott, ARN229MDUpstate Helicopter Services LLC · Rochester, NYN22EAHmc Lift LLC · Wilmington, DEN22NHSchuh Roger J · Chowchilla, CAN22PYEzell Holdings LLC · Tucson, AZN230MBFlyin Time LLC · Circleville, OHN231RLNor Wes Inc · Creston, IAN233HCA7p Trust Co Inc Trustee · Cheyenne, WYN234JRPortland Helicopters LLC · Portland, MEN235JPPechacek Justin · Snyder, TXN23EHTrevor Corp DBA · Grayslake, ILN23SDNorth Wind Aviation LLC · Chelan, WAN23TVKd Helicopters Inc · Shingleton, MIN23WKChemair Helicopters Inc · Jefferson, WIN243WWSunflower Helicopters LLC · Hebron, NE
Back to AD 89-10-11 R1