Skip to content

Registered aircraft · 137

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:2000-11-05') 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-11-05') 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:2000-11-05')
    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-11-05')
  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-11-05')
  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-11-05')
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.

N1004BJames R Cartillar III · Hickory Ridge, ARS/N 501-0022 N1005NMadsen Travis E · New Underwood, SDBuilt 1988 · S/N 401-0692 N1008QTall Towers Aviation Inc · Page, NDBuilt 1988 · S/N 401-0702 N1010LDevil Dusters Inc · Artesia, NMBuilt 1989 · S/N 401-0708 N1012TJohnson Airspray Inc · Argyle, MNS/N 401-0719 N1013FCorpora Aerial Service Inc · Hearne, TXBuilt 1989 · S/N 401-0721 N1013STr Flying Service LLC · Milan, MNBuilt 1989 · S/N 401-0724 N1014NFrontier Agricultural Service Inc · Calexico, CABuilt 1989 · S/N 401-0729 N1015AFrontier Agricultural Service Inc · Calexico, CAS/N 401-0735 N1015LInternational Air Services Inc Trustee · Carson City, NVBuilt 1989 · S/N 401-0730 N10192Frontier Agricultural Service Inc · Calexico, CABuilt 1989 · S/N 401-0731 N105DAKenmore Crew Leasing Inc Trustee · Bellingham, WABuilt 1986 · S/N 3010653 N1529WOlathe Spray Service Inc · Olathe, COBuilt 1992 · S/N 401-0848 N15439Dietz Timothy E · Wasilla, AKS/N 401-0862 N15449Headwaters Flying Service LLC · Three Forks, MTBuilt 1992 · S/N 401-0868 N1546UBauer Charles A · Graceville, MNBuilt 1992 · S/N 401-0873 N1546XHopkins Robert E Jr · Sumter, SCBuilt 1992 · S/N 401-0874 N1554KBasin Aviation Inc · Rio Oso, CAS/N 401-0882 N2137UNewberg Sky Spray LLC · Hector, MNS/N 301-0423 N23069Ag Spray Inc · Moorhead, MNBuilt 1981 · S/N 301-0350 N23095Bellamy Mark A · Freeville, NYBuilt 1981 · S/N 301-0356 N2314QPitt And Pitt Aviation · Wapato, WABuilt 1981 · S/N 301-0360 N2317ZCarlson Tatum D · Lake Bronson, MNBuilt 1981 · S/N 301-0364 N23219Thiel Air Care Inc · Chowchilla, CAS/N 301-0369 N23257Phoenix Equipment Lc · Nickerson, KSS/N 301-0371 N23260Snake River Aviation LLC · Pomeroy, WABuilt 1981 · S/N 301-0373 N23313Thomas Ag Aerial Inc · Thomas, OKBuilt 1981 · S/N 301-0376 N23600Hayton James B · Sedro Woolley, WAS/N 301-0398 N23616Putz Gary D · Hearne, TXBuilt 1981 · S/N 301-0400 N23647Marlow Aviation LLC · Lamoni, IABuilt 1981 · S/N 301-0407 N2367CThiel Air Care Inc · Chowchilla, CAS/N 301-0412 N2374WThomas Ag Aerial Inc · Thomas, OKBuilt 1982 · S/N 301-0428 N2378QMcguires Flying Service LLC · Obion, TNBuilt 1982 · S/N 301-0454 N23810Wenzel Richard E · Garretson, SDBuilt 1982 · S/N 301-0431 N2386WWhitten Flying Service Equipment LLC · Snook, TXS/N 301-0437 N299JHJohnson Airspray Inc · Argyle, MNBuilt 1990 · S/N 4010726 N301DKPetersen Dakota D · Kenmare, NDS/N 3010644 N301GLKroeplin Air LLC · Highmore, SDBuilt 1985 · S/N 301-0595 N301WDCarlson Production Services LLC · Norcross, MNBuilt 1978 · S/N 301-0143 N3157CTronstad Jorn · Sunnyside, WABuilt 1982 · S/N 301-0451 N3158ZThompson Frank L · Weiser, IDS/N 301-0457 N3159MRed Rdd LLC · Powell Butte, ORBuilt 1982 · S/N 301-0468 N3159PJarrett Airspray Inc · Jamestown, NDBuilt 1983 · S/N 301-0486 N3160TCurless Harley J · Havana, ILBuilt 1983 · S/N 301-0478 N31623Pitt & Pitt Inc · Wapato, WABuilt 1983 · S/N 301-0522 N3165ASchnoor Ag & Air LLC · Cambridge, MDBuilt 1984 · S/N 301-0544 N3165COmstead Jordan J · Lamoni, IABuilt 1984 · S/N 301-0545 N31676Associated Aerial Applicators · Lasalle, COBuilt 1984 · S/N 301-0560 N3167PMarlow Aviation LLC · Lamoni, IABuilt 1984 · S/N 301-0553 N3167TUltra Ag Cropdusters LLC · Le Mars, IABuilt 1984 · S/N 301-0554

Back to AD 2000-11-05