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.
N990BCMclaughlin Philip · Bakersfield, CAN990CBlaschka Michael T · Jacksonville, ORN990GGoebel Greg D · Petaluma, CAN990SAOn-Site Aviation Inc · Hillsboro, NDN990WYAmelia Reid Aviation LLC · San Jose, CAN9910YBaumgartner Larry C · Roseau, MNN9911YTyrrell Luke L · Fairbanks, AKN9914YKnapper Jack A · Hibbing, MNN9916YBennett S Leon · Van Alstyne, TXN991BCHusby Jeffrey L · Eau Claire, WIN9921YJohnson Jerry D · Bryan, TXN9925YDaniel Hull R · Wasilla, AKN9926YMorgan Kenneth K · Norridgewock, MEN9937YWoods Justin S · West Glacier, MTN9938YSchneider Bros · Manning, NDN9939YGehrke Walter L · Willow Lake, SDN9940YPiercy Ronald S · Moses Lake, WAN9942YHardy John R · Wasilla, AKN9943YDehlin James M · Roscommon, MIN994TAmerican Champion Aircraft Corp · Rochester, WIN9950YAnders Rod D · Wasta, SDN9953YBlock Larry F · Palmer, AKN9958YZimmerman Tom V Jr · Fairbanks, AKFirst renewal noticeN995JDCarrol Mears Farms Inc · Newport, ARN995WMHangar 7 Aviation LLC · N Redngtn Bch, FLN9961YSix One Yankee LLC · Rochester, MNN9967YDexter Fred H · Live Oak, FLN9968YDurham William R · Jasper, GAN9970YWeisenberger Michael J · Norwalk, OHN9971YSchad Tom J · Gainesville, TXN9974YAnderson Jennifer DBA · Oroville, CAN9976YRogue Air LLC · Miller, SDN9983YDesplinter Glen · Bettendorf, IAN9984YAllen Chorman & Son Inc · Milton, DEN9986SKaneaster Richard W · Port Orange, FLN9986YBillingsley Littleton C Jr · Spicewood, TXN9987YParker Steven Elliott · Bedminster, NJN9988YKw Air LLC · Darlington, INN998BHayton James B · Sedro Woolley, WAN998BCSky High Homes LLC · Etna, WYN9993YStukenberg Brian · Byron, ILN9994YSale Reported · Quincy, WASale reportedN9995YImhof Theresa L · Littlefork, MNN9997YLehrer James R · Thief River Falls, MNN999EFDowns Farm Inc · Lindsay, MTN999KLaroche Christopher S · Somerville, MAN999SPMcgilvray Andrea · Bandera, TXN99BJHarbock Inc · Wilmington, DEN99DTHougham Roger F · Mc Lean, ILN99GKInverted Holdings LLC · Newman, GA
Back to AD 2000-25-02 R1