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.
N90462Manning Mark D · Wrenshall, MNN9047BBooker Lisa M · Coeur D Alene, IDN9047LDaniel Bryan G · Childress, TXN9048BMark A Lenbom · Cameron, WIN9048ECarlson Nicholas · Waco, TXN9049FMiller Glenn E · Selma, CAN9049LOsborn Melissa L · Fairbanks, AKN904JBMitchell Thomas H · Batesville, MSFirst renewal noticeN9050BKarge Kent K · Quincy, CAN9050EBroadwell Eric B · Woodstock, GAN9050LOwen Alva A · Hilliard, FLN9051BFinished Work Aviation LLC · Redding, CAN9051EDexter Fred H · Live Oak, FLN9052BLucas John C · Sutter Creek, CAN9052LOlson Ronnie E · Palmer, AKN9053BKraken Aero LLC · Newport News, VAN9054BOber John A · Candor, NYN9054EStahl Carl L · Union Dale, PAN9055ERowletf Jeffrey D · Jonesville, VAN9055LJavelin Citrus LLC · Erda, UTN9056BPompeo John M · Gorham, MEN9057LKing Nathan A · Dunkirk, MDN9058BHigh Daniel M · Houston, TXN9058LLucius William C · Moosic, PAN905KTmd Enterprises LLC · Amarillo, TXN905NRState Of Minnesota · Grand Rapids, MNN9060BWaite Myron A · Pawlet, VTN9060LShank Paul L · Gaithersburg, MDN9062LR & B Helicopters Inc · Calhoun, GAN9063BPratt Patrick D · Martinisville, INN9063EDudley Shiloh W · Palatka, FLN9064BHogan Frederick D · Hamilton, OHN9064EWickenheiser John · Newport, MIN9064LHendrickson Don W · Helena, MTN9066LPasco Gary R · Brockport, NYN9067LGabriel Thomas G · Clinton, PAN9068BTherriault Charles W · Auburn, NHN9068EMarsh Steven A · Eaton Rapids, MIN9069BDemello Michael B · Phoenix, ORN9069LCitabria Flyers LLC · North Salt Lake, UTN906NCactus Pilots LLC · Tulsa, OKN9070BDavis Hunter R · Morgan, TXN9071BLaney Kevin D · Maiden, NCN9071LWolfley Jody K · Mountain Home, IDN9072CBerg Michael S · Eleva, WIN9073LRegistration Pending · Munford, TNRegistration pendingN9074BWasik Marvin B · Hernando, FLN9074LTillotson Bradley T · Loveland, OHN9075BLaney Charles A · Maiden, NCN9075LSibbernsen William · Omaha, NE
Back to AD 2000-25-02 R1