Registered aircraft · 341

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:80-04-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:80-04-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:80-04-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:80-04-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:80-04-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:80-04-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.

N10009Hendrickson Flying Service Inc · Rochelle, ILBuilt 1979 · S/N 79-032 N1001FAg Air Inc · Cheyenne, WYBuilt 1979 · S/N 79033 N100HTMitchell Brian N · Scottsdale, AZBuilt 2010 · S/N 2 N101MFUsda Forest Service Fepp · Trenton, NJBuilt 1957 · S/N 1953 N1023VPeterson Chester L · Willis, TXS/N 2021 N102BBNester Randal K · Seguin, TXBuilt 1959 · S/N 1107 N106HHHaddock Flying Service Inc · Salters, SCS/N 1375 N10RNExecutive Jet A LLC · Danbury, CTBuilt 1948 · S/N 2229 N1139WMundis Jay E · Red Lion, PABuilt 1964 · S/N 3164 N1150WBoho LLC · Lewes, DEBuilt 1964 · S/N 3327 N115SLDykstra Donald J · Dorr, MIS/N 7694 N1184WJohnson Kyle L · Exira, IABuilt 1965 · S/N 3341 N119NRSlikker Flying Service Inc · Buttonwillow, CABuilt 1966 · S/N 1472 N11CUPockrus Pat B · Mineral Wells, TXBuilt 1957 · S/N 983 N1201YHhi Farms LLC · Hamilton, MIBuilt 1979 · S/N 78-024 N1202WTriple F Flying Inc · Benton, PABuilt 1967 · S/N 7857 N12220Dixon Craig S · Rimrock, AZBuilt 1958 · S/N 2267 N12RNSunshine Holding LLC · Danbury, CTBuilt 1965 · S/N 3350 N12UHJstream Lc · Sheridan, WYBuilt 1962 · S/N 1395 N130HAC&C Helicopters Inc · Kuna, IDS/N HA3030 N130VJ Bird Air Service LLC · Cheyenne, WYBuilt 1958 · S/N 2230 N1311XBrown Helicopter Inc · Pensacola, FLBuilt 1966 · S/N 7823 N1315XRitel Copter Service Inc · Hudson, IABuilt 1966 · S/N 7816 N13298Lidija LLC · Grass Valley, CAS/N 1346 N132HASky Copters Inc · Westmoreland, KSBuilt 1975 · S/N HA3032 N133HAHanson Leasing Inc · Bad Axe, MIBuilt 1976 · S/N HA3033 N1342XHhi Farms LLC · Hamilton, MIBuilt 1965 · S/N 7531 N1347XChurchill Scott W · Le Sueur, MNBuilt 1966 · S/N 7829 N1374XTriple F Flying Inc · Benton, PABuilt 1966 · S/N 7839 N1396XHammock Flying Service Inc · Smithville, ARBuilt 1967 · S/N 7570 N139HAKnutson Flying Service Inc · Tioga, NDBuilt 1976 · S/N HA3039 N1420WHammock Flying Service Inc · Smithville, ARBuilt 1969 · S/N 7663 N1449WRitel Copter Service Inc · Hudson, IABuilt 1969 · S/N 7931 N14637Fort Wolters Helicopter Inc · Mineral Wells, TXBuilt 1993 · S/N 1577 N1470WSmith Peter I Trustee DBA · Ocala, FLS/N 7935 N147SMMazar Stephen M · Flushing, MIBuilt 1956 · S/N 1461 N14861Brown Helicopter Inc · Pensacola, FLBuilt 1972 · S/N 25089 N14EFInternational Air Services Inc Trustee · Carson City, NVBuilt 1988 · S/N 4622009 N14MQFort W0lters Helicopter Inc · Mineral Wells, TXBuilt 1961 · S/N 1474 N1501LMonahan Robert J · Bulverde, TXBuilt 1971 · S/N 25046 N1503LTriple F Flying Inc · Benton, PABuilt 1971 · S/N 25042 N1512EFort Wolters Helicopters · Mineral Wells, TXBuilt 1965 · S/N 1792 N1523TBartlett Robert E · Cleveland, TXBuilt 1964 · S/N 1740 N152DBDurango LLC · Brownsville, TXBuilt 2000 · S/N 3257135 N15395Magnum Aviation LLC · Goff, KSS/N 2408 N153AFarwest Aviation LLC · Billings, MTBuilt 1966 · S/N 3550 N161SHChurchill Dianne L · Jordan, MNBuilt 1976 · S/N 1921 N16NRParagon Helicopter Services LLC · Claremore, OKBuilt 1964 · S/N 1755 N170HFEfinance LLC · Wichita, KSBuilt 1968 · S/N 3687 N17HHendrickson Flying Service Inc · Rochelle, ILBuilt 1947 · S/N 13

Back to AD 80-04-04 R1