AD 2000-25-02 R1
Registered aircraft · 7,563
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:2000-25-02-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:2000-25-02-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:2000-25-02-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:2000-25-02-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.
N83703Rensberger Scott C · Lake Jackson, TXN83710Ellis Chad A · Chrisman, ILN83711Cameron Thomas J · Stanchfield, MNN83715Middlebrook Paul E · Penn Yan, NYN83716Florczyk Raymond S II · Clay, NYN83719Makely Abraham M · Culpeper, VAN8371VPrairie Thermals LLC · Brookings, SDN83720Elliott Ryan A · Gallipolis, OHN83725Tubbs Allan R · Greenvlle Jct, MEN83729Haldeman Richard R · Mt Juliet, TNN8372VVarwig Korrey L · Peoria, ILN83732Steenblik Jan W · Bloomington, INN83733Nohlquist James L · Rochester, NYN83735Mason Thomas M · Meredith, NHN83739Ala Coast Vintage Biplanes LLC · Irvington, ALN8373VSeidler Marlyn L · Underwood, NDN83746Alfredo Cordero · Mc Alpin, FLN83748Hochstetler Jared W · Cheyenne, WYN8374VDexter Fred M · Live Oak, FLN83751Easy Street Aviation LLC · Braxton, MSN83756Longuski Francis J · Vassar, MIFirst renewal noticeN83757Anderson Thomas C Jr · Toone, TNN83758Jella Christopher R · Jefferson City, MON8375VCarll Elizabeth M · Chicago, ILN83760Registration Pending · Hattiesburg, MSRegistration pending, canceledN8376VKirkeby Dean A · Clark, SDN83771Wenzel Harry A · Medford, ORFirst renewal noticeN83773Wallace Christopher L · Albuquerque, NMN83774Hansen Eric P · Arlington, WAN8377VWeber William A · Brodhead, WIN83780Hoffman Willam C · Rostraver Township, PAN8378VDollins Carl E · Grosse Ile, MIN83790Harlow Timothy P · Spring, TXN83791Van Farowe Gary A · Hudsonville, MIN83792S Dacy Enterprises Inc · Harvard, ILN83797Felda Flyers LLC · Felda, FLN83800Armstrong Robert A · Canby, ORN83802Floren Donald D · Royal City, WAN83805Mazure Glenn J · Bad Axe, MIN83806Sheaffer Douglas P · Narvon, PAN8380VMaxwell Frank R · Fairbanks, AKN83812Casner Bruce W · Jeffersonton, VAN83813Elbert County Air Force LLC · Elbert, CON83822Christmann James C Trustee · Santa Cruz, CAN83823Thompson Chase M · Carthage, MON83824Talutis William R · Murchison, TXN83835Ltg Enterprises LLC · Fort Wayne, INN83837Davenport Jimmy J · Hayesville, NCN83838Morrison James J II · Grandview, TXN83842Reeves Jeffrey A · Bothell, WA
Back to AD 2000-25-02 R1