Skip to content

Registered aircraft · 54,017

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:87-20-03-R2') OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:87-20-03-R2') 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:87-20-03-R2')
    OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:87-20-03-R2')
  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:87-20-03-R2')
  OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:87-20-03-R2')
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.

N4240142401 LLC · Hailey, IDBuilt 1973 · S/N 18052350 N42409Ross Leslie W · Truckee, CAS/N 18259006 N4240QPerry Nicklette Knight · Port Arthur, TXBuilt 1971 · S/N 17260140 N4240UDennis P Berky Enterprises LLC · Winder, GAS/N 15060240 N4240VLadage Terry L · Champaign, ILBuilt 1948 · S/N 18596 N4241FPankhurst Terrell K · Lauderdale, MSBuilt 1958 · S/N 46141 N4241LAshland Flyers LLC · Bayfield, WIBuilt 1966 · S/N 17254310 N42421Registered aircraftBuilt 1968 · S/N 18259011 N42424Bowyer Charles W Stephen · Tucson, AZBuilt 1968 · S/N 18259013 N42428Hantzsche Jackson R · Wellington, NVBuilt 1968 · S/N 18259014 N4242CCas LLC Trustee · Ballinrobe Co MayoS/N 172-49187 N4242FChronis Marc D · Pembroke, NHBuilt 1958 · S/N 46142 N4242LHannon Douglas L · Yakima, WABuilt 1966 · S/N 17254311 N4242QRegistered aircraftS/N 17260142 N4243FEagle Glen Veterinary Services Inc · Corona, CAS/N 46143 N4243LNorth Central Marketing Inc · Cranston, RIBuilt 1966 · S/N 17254312 N4243UN4243u LLC · Wilmington, DEBuilt 1963 · S/N 15060243 N42441Grizard Diane M · Simi Valley, CABuilt 1968 · S/N 18259018 N4244CBusking Ryan · Houston, TXBuilt 1978 · S/N R18200341 N4244QCox Danny · Peachtree City, GABuilt 1971 · S/N 17260144 N4244SGolden Eagle Outfitters Inc · Delta Junction, AKS/N U20603814 N4245CLogan Gregory A · Chouteau, OKBuilt 1978 · S/N R18200342 N4245LAero Missions Inc · Sylacauga, ALBuilt 1966 · S/N 17254314 N42460Leofsky Richard J · Willis, TXBuilt 1968 · S/N 18259024 N42461Eurice Brian R · Bradenton, FLBuilt 1968 · S/N 18259025 N42464Gunderson Gunnar Jr · Wrangell, AKBuilt 1973 · S/N 18052356 N42465Nadalin David D · North Fort Myers, FLBuilt 1968 · S/N 18259027 N4246CDodson International Parts Inc · Rantoul, KSFirst renewal noticeBuilt 1978 · S/N R18200343 N4246QJkg LLC · Murfreesboro, TNBuilt 1971 · S/N 17260146 N4246VMesserly John A · Altus, OKBuilt 1948 · S/N 18602 N42471Livestock Innovations Inc · Easton, MNBuilt 1968 · S/N 18259030 N4247QSchmitt Michael C · Alva, FLS/N 17260147 N42482Dancing Bear Market Inc · Fresno, CABuilt 1968 · S/N 18259033 N42484Hiemstra Ralph W · Sonora, CAS/N 18259035 N42485Kaiser Enterprises Inc · Carrollton, MOBuilt 1968 · S/N 18259036 N42486Armstrong Kevin L · Corvallis, ORBuilt 1973 · S/N 18052357 N4248CSchneider Franz E · Bacliff, TXBuilt 1978 · S/N R18200345 N4248FWilcox Ross P · Newark, DEBuilt 1958 · S/N 46148 N4248LOney Marilyn S · Beach City, OHBuilt 1970 · S/N 18260226 N4248QPhysics Aviation LLC · Jonesboro, ARBuilt 1971 · S/N 17260148 N4248UEyles Benson G · Hampden, MEBuilt 1963 · S/N 15060248 N42492Mcdermott Brian D · Fairbanks, AKBuilt 1968 · S/N 18259042 N4249LKraus Gary L · Holbrook, PABuilt 1966 · S/N 17254318 N424ADSky West Aviation Inc Trustee · Albuquerque, NMS/N 20700337 N424BCPikeside Flying Club Inc · Martinsburg, WVBuilt 1964 · S/N 17252171 N424CBLesnett Robert G · Novato, CABuilt 1968 · S/N 18258975 N424DDMaple Aviation LLC · Big Fork, MTBuilt 1972 · S/N 18261424 N424LSQualitair LLC Trustee · MichelstadtBuilt 1975 · S/N F177RG0130 N424MKMkt Aviation LLC · Mankato, MNBuilt 1978 · S/N 15281808 N424NTLattin Travis · Beloit, KSBuilt 1957 · S/N 34555

Back to AD 87-20-03 R2