AD 80-25-07 R1
Registered aircraft · 25,370
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:80-25-07-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:80-25-07-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:80-25-07-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:80-25-07-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.
N1822GWhr Sales LLC · Riviera Beach, FLFirst renewal noticeN1822QPopiol Victor · Doral, FLN1824RKleissas Constantine · Wye Mills, MDN1826GSelting Mark D · Kadoka, SDN1826QMiller Brent R · Orefield, PAN1827GSpangler Anthony J · Bethel, AKN1828Van Nice Alexander W · Wasilla, AKN1829QMaracle Wayne M Jr · Papillion, NEN182AJN182aj LLC · Hamilton, MTN182BESimmons Charles · Cora, WYN182BLMccaan Jerome · Bethel, MEN182BZBaker John J · Tucson, AZN182CFJunell Justin · Zuni, NMN182CWFernandez Miguel A · Merritt Island, FLN182DKTonso Antonio · Roseville, CAN182ESwanson Jorge A · Douglas, AZN182EB182 Flyers LLC · Spartanburg, SCN182EGBurnette Ric · Sebastian, FLN182FBDownwind Abeam Inc · Pasadena, CAN182GZAircraft By Farkas LLC · Middleburg Heights, OHN182HATurner Company LLC · Hearne, TXN182HCDrake Craig C · Brandon, MSN182JFLeah LLC · Center Conway, NHN182KCBas Part Sales LLC · Greeley, CON182KSAltivor LLC Trustee · Sheridan, WYN182MJNelson Theresa H · Knoxville, TNN182NCKrizauskas David F · Moncks Corner, SCN182RNNensel Richard E · Sylvania, OHN182RVSwift John S · Ventura, CAN182SHColes Robert John Jr · Santa Barbara, CAN182SPT Mark Fay Consulting Inc · Naperville, ILN182UKarl Mark G · Wilbraham, MAN182WDLewis W D III · San Carlos, CAN182ZSGil Ricardo G · New Braunfels, TXN1831GGee3 LLC · Sardis, MSN1831QLovejoy Russ · Vian, OKN1832GThomas Robert D Jr · Tulsa, OKN1832QSimmons Gordon W · De Leon Springs, FLN1834RRadford David M · Glen Cove, NYN1835QGreen Wendell C · Live Oak, CAN1836GJensen Steven M · Tioga, NDN1836QUebersetzig Joshua · Monrovia, CAN1837QHenry Mark S · Endwell, NYN1838GNickelson Gene A · Weskan, KSN183ACSynnes Mark A · Halliday, NDN183BBRussell Charles B DBA · Union City, TNN183RAYaggie Allen · Wahpeton, NDN183RLJe Air LLC · Bayamon, PRN183SPIndian River Flying Club Inc · Rockledge, FLN1840GJulicher Mark R · Bulverde, TX
Back to AD 80-25-07 R1