AD 85-22-11 R1
Registered aircraft · 93
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:85-22-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:85-22-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:85-22-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:85-22-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.
N1017Jednacz Scott T · Bixby, OKN1055WMidwestern Soaring Association · Peculiar, MON1059DRafferty Michael J · Santa Monica, CAN105MAckley Richard F · Clearville, PAN105SHolden Daniel N · Anacortes, WAN1106BWillat Garret · Warner Springs, CAN111CRCramer Warren C · Horseheads, NYN1124TEiland Eddie L · Dublin, TXN1143Bruder Niclas · Portland, ORN116RBRatzin Brendan · Pahrump, NVN11GVGrah David B · Bishop, CAN11RDHolmes Alonso P · Broomfield, CON123EWMadigan Gregory J · Fort Montgomery, NYN1263Browning John · Blairstown, NJN1275Martin William F · San Antonio, TXN12RUAlbuquerque Soaring Club · Albuquerque, NMN130GLDziedzic Jan B · Plainfield, ILN1355Knerr Joshua D · Tehachapi, CAN152FLevas Timothy J · Cardiff By The Sea, CAN1599Willamett Valley Soaring Club · Cornelius, ORN1699Lowry Steven D · Waialua, HIN174NEKoenig Colleen M · Edgewood, NMN17BIndrebo James E · Healdsburg, CAN1811TWahl John F · Edgewood, NMN1894Reusch David C · Seattle, WAN18LMartin J Campbell · Tehachapi, CAN194PBauman Jennifer · Tehachapi, CAN1971SAuburg George R · Midland, TXN1XEDiaz Allison Violette · Stephens City, VAN21PTGary Oswald Lee · Post Falls, IDN2200Wendland Frank A · SiegenN221ERensel Daniel J · Ashville, NYN230GWahl John F · Edgewood, NMN2349Hite Douglas T · Frisco, TXN245FForney James C · Spokane, WAN2509Bjork Richard J · Brackettville, TXN2578Davis Clinton B · Bakersfield, CAN2677Tobin Scott R Jr · Port Orange, FLN2926Martucci Dennis J · Monroe, GAN2972Macveigh John D · Thomasville, PAN3012Western Antique Aeroplane & Automobile Museum · Hood River, ORN3013Kucera Nathaniel Paul · Covington, KYN3019Davies Harry Francis · California, MDN301BWBerry Wallace D Jr · Lafayette, ALN301JMahony John P · Schenectady, NYN301NRead Roderick F Jr · Grayslake, ILN301QMcgarraugh Barry L · Minden, NVN301RGWebb James T · Plantersville, MSN301RPSale Reported · Coupeville, WASale reportedN306MKCarlson Michael L · Shelbyville, KY
Back to AD 85-22-11 R1