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.
N82093Oborny Alan R · Choteau, MTN82095Hirschel Arthur D · Eureka, SDN82098Arbaugh Joanne N · Harbor Springs, MIN82099Henricks Terry E · Archbold, OHN820SDBachman Ryan · Mesa, AZFirst renewal noticeN82101Sutherland Johnny Leon · Goldthwaite, TXN82103Petro Jerry R · Williamsburg, VAN82104Caulkins Howell V · Chico, CAN82105Ennis Michael J · Eminence, MON82106Morrison Lillian M · Port Townsend, WAN82107Mclavy Michael J · Puyallup, WAN82113Strain D Bret · White River, SDN82117Johnson Scott E · Union Bridge, MDN82125J & D Services Inc · Wilmington, DEN82129Gruhlkey Cameron T · Dalhart, TXN82134El Paso Flying Service LLC · El Paso, ILN82135Willis Roger · Belleview, FLN82137Abbott Dylan L · Lompoc, CAN82138Abrahamson Duane E · Manawa, WIN82140Bingham Sammy J · Manvel, TXN82142Snell Gary A · Dresden, MEN82146Sale Reported · Williamson, NYSale reportedN82147Sipes Robert L · Mound City, MON82150Houghton Robert E · North Ferrisburgh, VTN82151Gramke Thomas · Tekamah, NEN82153Catlin Vaughn H · Mardela Springs, MDN82154Hutter Charles G · Carson City, NVN82158Noble Wendell · Nicholasville, KYN82159Morris Larry R · Guntersville, ALN82160Coop David L · Albia, IAN82170Colombe George L · Wentworth, SDN82179Sibbitt Alice N · Chandler, AZN82181Hester James T · Fayetteville, GAN82183Westland Mark Eric · Saint George, UTN82184N82184 LLC · Indianapolis, INN82187Dolder Gary E · Waterman, ILN82199Syverson Michael B · Waubun, MNN82200Markwood Hannah E · Anchorage, AKN82201Mgs Ventures Ltd · Wilmington, DEN82202Air-K Enterprises LLC · Weirsdale, FLN82205Mcinerny Charles H Jr · Dansville, NYN82206Braswell Randall A · Wisner, LAN82215Robinson Michael F · Decatur, ALN82219Myakka Head Aviation LLC DBA · Bradenton, FLN82220Snyder Jason D DBA · Oakland, MDN82230Grieser James K · Wauseon, OHN82234Long Kenneth L · Everett, WAN82235Begley Scott R · Fairbanks, AKN82244Burgess Edward P · Elizabethtown, KYN82245Prather Carl L · Gilroy, CA
Back to AD 2000-25-02 R1