AD 91-22-01
Registered aircraft · 1,527
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:91-22-01')
OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:91-22-01')
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:91-22-01') OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:91-22-01') 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.
N10007Insko Matthew T · Papillion, NEN100BMarshall Xavier T · Carson, CAN101JHHi-Per Aviation Inc · Arroyo Grande, CAN101PQValiair Limited Company Trustee · Casper, WYN1024Calgonaire LLC · Seminole, TXN10242Alexander Holding Services Inc · Newark, DEN1067MShore Enterprises Of Gainesville LLC · Gainesville, FLN109HBadke Paul J · Ray, MIN10DBBrandon Donald A Trustee · El Monte, CAN10HGGerardy Harlan D · Gruver, TXN10HLHoyt Robert H Trustee · Canby, ORN10RVKoehn Shane Michael · Scooba, MSN10YSeitz William D · Gordonville, TXN110BDArgus Craig J · Atlantic City, NJN110YDLloyd Clee · Canby, ORN1110SMob Aviation USA LLC · Kissimmee, FLN1137MN1137m LLC · Bentonville, ARN115CWWhitlock Gary D · Melbourne, FLN1190QBritell Andrew Paul · Sandwich, NHN119MSAeronorth LLC · Ann Arbor, MIN11LATwo-Ten LLC · Ramona, CAN1205BEngel Shane J · Willow, AKN121CEAdvanced Flight Instruction LLC · Greenwood, DEN122FSiver Creek Capital LLC · Emery, SDN123CEBas Part Sales LLC · Greeley, CON123KTHolliday Paul B · Kiln, MSN123UAwg Aviation LLC · Ainsworth, IAN125CFInternational Air Services Inc Trustee · Carson City, NVN126LSMerritt Aaron S · Manhattan, MTN1299MMoanaviation Inc · Tampa, FLN12KFN12kf LLC · Pass Christian, MSN12PWOhio State University College Of Engineering · Columbus, OHN12RFMckay Jonathan S · Chesapeake, VAN12VMS & R Air Inc · Asheville, NCN12WDHamburg Jeffrey · Corsica, SDN1314UKilgore Don H · Jasper, ALN1329UA C W Inc · Gonzales, LAN1333TWoodford Michael F · Fabius, NYN136JRaichl John P · Astoria, ORN1397MRichs Inc · Wilmington, DEN13BJSevcik Clint · Medford, MNN141DMTurbo Inc · Flint, MIN143TCHarris William D · Topeka, KSN145PPainter Bryan J · Renton, WAN14LVSmetana Louis V III · Blair, NEN154BCTen Knot Tailwind LLC · Mesa, AZN154EFAdams Donald C · Garner, NCN155KTN155kt LLC · Dover, DEN1574PSouthern Seaplane Inc · Belle Chasse, LAN157LMBaughman David · Jeffersonville, IN
Back to AD 91-22-01