Registered aircraft · 1,467

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

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:2001-10-04-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:2001-10-04-R1') ORDER BY n_number

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:2001-10-04-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:2001-10-04-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:2001-10-04-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:2001-10-04-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.

N90210Robertson Crop Dusting Service Inc · South Haven, MIBuilt 1992 · S/N 402-0889 N902MAMaxwell Ag Aviation LLC · Sterling, KSBuilt 2005 · S/N 502B-2592 N902MCBank Of Utah Trustee · Salt Lake City, UTBuilt 2024 · S/N 802-1107 N90319Stevenson Flying Service Ll · Selden, KSBuilt 1999 · S/N 502B-0578 N9032TBarts Flying Service Inc · Storm Lake, IABuilt 2000 · S/N 402A-1130 N9033NJohn Georg Aerial LLC · La Crosse, KSBuilt 1999 · S/N 402A-1097 N9037NOutwest Aviation LLC · Hamilton, MTBuilt 1999 · S/N 802A-0083 N904MHAerial Crop Services LLC · East Prairie, MOBuilt 2021 · S/N 802-0904 N9053SShearer John W · The Dalles, ORBuilt 1992 · S/N 402-0890 N90614Air Care Systems Inc · Lamar, COBuilt 1999 · S/N 502B-0592 N9071ZJohnson Airspray Inc · Argyle, MNBuilt 2001 · S/N 401B-1131 N9074HAg Monkey Inc · Norris City, ILBuilt 1999 · S/N 502B-0559 N90772Ag Enterprises LLC · Flagler, COBuilt 1999 · S/N 402A-1112 N9078GA W Peterson Inc · Warren, MNFirst renewal noticeBuilt 1995 · S/N 802A-0015 N90802Ag Air LLC · Washington, IABuilt 2000 · S/N 802A-0092 N9082CDakota Air Spray LLC · Huron, SDBuilt 1992 · S/N 502-0193 N908LARoth Aerial Spraying LLC · Milford, NEBuilt 1994 · S/N 502A-0262 N90902Midway Air Services Inc · Minter City, MSBuilt 2000 · S/N 502B-0613 N9090MIndependent Dusting Service Inc · El Campo, TXBuilt 2000 · S/N 402B-1122 N9090QWilstine Aviation LLC · Leoti, KSBuilt 1992 · S/N 502-0195 N9090YThiel Air Care Inc · Chowchilla, CABuilt 2000 · S/N 502B-0616 N9091UMeadow Creek Aerial Application Inc · Kelliher, MNBuilt 2000 · S/N 402A-1119 N9094TAcadian Dusters LLC · Church Point, LABuilt 2000 · S/N 502B-0600 N909TATunica Air Inc · Tunica, MSBuilt 2020 · S/N 802A-0866 N90WWAeronautical Technologies Inc · Clovis, NMBuilt 2013 · S/N 802-0489 N91092Wakefield Aircraft LLC · Cooperstown, NDBuilt 1993 · S/N 802A-0005 N91099Henderson Ag Service Inc · Osceola, ARBuilt 2024 · S/N 802A-1165 N910BPBank Of Utah Trustee · Salt Lake City, UTBuilt 2023 · S/N 502A-3419 N9119BWoodley Aerial Leasing LLC · Walnut, ILBuilt 2000 · S/N 802-0100 N911BTAaa Aviation LLC · Donalsonville, GABuilt 2018 · S/N 802-0771 N911CRCedar Ridge Aviation LLC · Knox City, TXBuilt 2025 · S/N 802-1264 N911PLAir Xpress LLC · Wilmington, DEBuilt 2019 · S/N 802A-0805 N911RNDixie Air Applicators LLC · Itta Bena, MSBuilt 2022 · S/N 502B-3344 N9124FCentral Iowa Agricultural Aviation LLC · Wellsburg, IABuilt 2001 · S/N 502B-0638 N91262Busby James D II · Port Saint Lucie, FLBuilt 2001 · S/N 502B-0640 N91266Air Dusters Inc · Roggen, COBuilt 2001 · S/N 402A-1134 N9129ZAir-Trac Inc · Pasco, WABuilt 2001 · S/N 502B-0626 N9134ARosewood Air LLC · Plaucheville, LABuilt 2001 · S/N 502B-0624 N91357Wilde Air Service LLC · Volga, SDBuilt 2000 · S/N 802A-0107 N91358Kubecka Daniel P · Edna, TXBuilt 2001 · S/N 802A-0109 N9135FRba LLC · Kimberly, IDBuilt 2001 · S/N 802A-0117 N9136ULewis Flying Maintenance Service · Morse, LABuilt 1993 · S/N 502-0204 N91398Tri-Air Farms LLC · Mamou, LABuilt 2001 · S/N 802A-0111 N913LLBoedeker Flying Service East LLC · Childress, TXBuilt 2022 · S/N 802A-0988 N9143FStove Creek Air LLC · Unadilla, NEBuilt 1992 · S/N 502-0197 N9148CPrecision Aerial Ag LLC · Seneca, KSS/N 502B-0632 N914BRFitchs Flying Service LLC · Pearsall, TXBuilt 1992 · S/N 502-0189 N914RARegistered aircraftBuilt 2021 · S/N 802A-0879 N9152CLewis Flying & Maintenance Service Inc · Morse, LAFirst renewal noticeBuilt 1993 · S/N 5020205 N9152RFlatland Aviation LLC · Indianola, MSBuilt 1989 · S/N 502-0203

Back to AD 2001-10-04 R1