AD 83-22-01 R1
Registered aircraft · 924
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:83-22-01-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:83-22-01-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:83-22-01-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:83-22-01-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.
N4724PTnt Farms · Marana, AZN4728PSheppard Harold DBA · Riverton, WYN4731PBas Part Sales LLC · Greeley, CON4750PKenefick Christopher Keith · Rosamond, CAN4757PRenck Michael R · Red Rock, TXN4758PCole Gary L · Richmond, TXN4782POlson Allan K · Tarpon Springs, FLN4799PPlayer Dennis · Union Bridge, MDN47EEGt Aviation Solutions LLC · Mount Juliet, TNN47MKAztec Aviation Two LLC · Augusta, GAN47RLUpstate Aircraft Leasing LLC · Wilmington, DEN4823PWilliams Charles S · Pearland, TXN4833PPacifica LLC · Grand Junction, CON4843PSherrill L H · Tucson, AZN4851PTwin Air Assets LLC · Casper, WYN4853PSwan Aviation Ministries Inc · Baker, FLN485EDSouthern Aircraft Consultancy Inc Trustee · Casper, WYN4883PMardis James T · Mechanicsburg, PAN4893PTri-City Helicopter Services Inc · Richland, WAN4895PKlein Barry A · Friday Harbor, WAN4899PC E S Corporation · Charleston, WVRevoked, canceledN48YKimble Robert · Marco Island, FLN4904PCivil Air Support LLC · Phoenix, AZN4907PTabor Conor C · Littleton, CON4916PPiper Aviation Museum Foundation · Lock Haven, PAN4920PDetert Bradley · Valparaiso, INN4921PAndre David E · San Jose, CAN4930PRegion Flyers LLC · Valparaiso, INN4934PAlm Holding LLC · Winton, CAN4940PArpey Aviation Ltd · Colleyville, TXN4942PSchulz Beverly A · Merrill, WIN4949PSonn Jeffrey R · Descanso, CAN4951PKnights Aviation Services LLC · Westlake, OHN4955PJuber Glenn E · Coconut Creek, FLN4961PSimmons Aviation Services LLC · Pawcatuck, CTN4965PKittner Robert T · Ellenville, NYN496JDDonnelly Jamy Christopher · Crystal River, FLN4971PDodt Clinton Carl · Broomfield, CON4973PAviation Business Corp · Saint Louis, MON4980PLewis Clinton A · Antlers, OKN4981PTri State Aero Inc · Martinsburg, WVN4984PMoore Bruce W · Aledo, TXN4986PLms Aviation LLC · Omaha, NEN4987PRegion Flyers LLC · Valparaiso, INN499CRAce Tomato Company LLC · Daytona Beach, FLN49BMHarriman Aviation LLC · Pearland, TXN49RDDziak Chester · Jackson, MIN4DRTotah John E · Kailua Kona, HIN4VSAircraft Montana LLC · Helena, MTN5008AWings Like Eagles LLC · Wilmington, DE
Back to AD 83-22-01 R1