AD 91-22-01
Registered aircraft · 1,525
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.
N1839FHentz Randy Reuben · Tower City, PAN1842ZVermont Skydiving Adventures Inc · Bristol, VTN1843FJordan Jay · Centre, ALN1843ZVacek George T Jr · Anchorage, AKN1844ZN1844z LLC · Hillsboro, ORN1845FJones Sandy Ray · Williamsburg, NMN1848ZBritt Robert J · Augres, MIN1849FCrouse William F · Priest River, IDN1852FSymbot Management Inc · Dover, DENon-citizen corporation, flight hours not reportedN1854FHarlan Bradley J · New Brighton, MNN1854ZBargabos William M · Wasilla, AKN1858ZPairofminutes LLC · Marshville, NCN1859FBaker Robert J · Ogema, MNN1861ZPadden Geary L · Duluth, MNN1863FAndersen Dana K · Scappoose, ORN1864FSwensen Nathan E · Winnemucca, NVN1865ZBpf Equipment LLC · Burnet, TXN1867FIcarus Aviators LLC · Canon City, CON1868ZZulu Forty One LLC · Anchorage, AKN1869FRegistration Pending · Dublin, OHRegistration pendingN1869ZPinnell Bradley T · Lake Havasu City, AZN186RDWayson Air LLC · Mount Auburn, IAN1870FWilliams Aviation LLC · Indianola, IAN1870ZZerkel Kirk Zachary · Wasilla, AKN1871FGorham Neil M · Memphis, TNN1874ZSiggard Kurtis K · Sacramento, CAN1875FMcfadin T E · San Antonio, TXFirst renewal noticeN1876ZHzl Hanger LLC · Drums, PAN1877FHoots Kent B · Macon, GAN1878ZRpm Diesel LLC · Grants Pass, ORN1879FKris Noone Air LLC · Wilmington, DEN1879ZQuad City Skydiving Center Inc · Coal Valley, ILN187MMSelf Aviation LLC · Hayden, IDN1882ZConstable William H · Rch Palos Vrd, CAN1883FAnkeney Scott · Canyon, TXN1887FHeadings Kevin · Echo, ORN1887ZDavidson David R · Sutton, AKN1889FPiper Henry Burton Jr · Kingston, TNN1890ZAlaniz Jose M · Yreka, CAN1892FPanagotacos George · Corona, CAN1893FKleeman Mark · Kearney, MOFirst renewal noticeN1894ZEverly Peter · Fort Smith, ARN1898ZSmart Robbie A · Wasilla, AKN1899ZLarlee Coleman R · Millbrook, ALN18NFR D Aviation LLC · Phoenixville, PAN18PWPhenix LLC · Dayton, WAN1943MBenbrook Robert A · Blairstown, NJN198PBolski Dariusz · Rancho Cordova, CAN198RPAircraft Guaranty Corp Trustee · Oklahoma City, OKN1YDBerg Bradley · Tulare, CA
Back to AD 91-22-01