Skip to content

Registered aircraft · 1,686

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:71-09-07-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:71-09-07-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:71-09-07-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:71-09-07-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:71-09-07-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:71-09-07-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.

N5426CVirginia Air Inc · Roanoke, VABuilt 1979 · S/N 21063749 N542CGulf States Financial Services · Lafayette, LAS/N 21063919 N542EBSvoboda Erik S · Mentor, OHBuilt 1981 · S/N 21064351 N5430AAdams Hay Farms LLC · Cedar City, UTBuilt 1979 · S/N 21063433 N5434ASteele Group Insurance Agency Inc · Eugene, ORBuilt 1979 · S/N 21063436 N5436UNewsom William Joel III · Roswell, GAS/N 21064892 N5439CLopez Hugo E · Mcallen, TXFirst renewal noticeBuilt 1979 · S/N 21063755 N543EMPacific Air Flight School LLC · Long Beach, CABuilt 1978 · S/N 21063054 N5456YWings As Eagles LLC · Wilmington, DES/N 21064211 N545ML3rd Coast Air LLC · Traverse City, MIS/N 21062821 N545PSUnited States Department Of The Interior · Boise, IDBuilt 1983 · S/N U20606702 N5464VLivingood Richard A · Tucson, AZS/N 21060955 N5467APiedmont Air Services LLC · Helena, MTBuilt 1979 · S/N 21063454 N5482CSantiago Robert S · Torrance, CABuilt 1979 · S/N 21063764 N5486ABas Part Sales LLC · Greeley, COS/N 21063464 N5490AN5490a LLC · Rutherfordton, NCBuilt 1979 · S/N 21063467 N5493AValley Dairy Farms Inc · Roy, WAFirst renewal noticeS/N 21063469 N5495ARzs Enterprises Inc · Finley, NDBuilt 1979 · S/N 21063470 N5495VPhillips Ruffin P Jr · Lexington, NCBuilt 1975 · S/N 21060964 N54AKGreat Planes Reproductive Centers Pa · Circle Pines, MNBuilt 1981 · S/N 21064473 N54DZMcdonald Donald F · Greer, SCBuilt 1983 · S/N 21064820 N54KDSawtooth Flying Service Inc · Mccall, IDBuilt 1981 · S/N U20606181 N550MTLiving Sky Grains LLC · Three Forks, MTBuilt 1982 · S/N 21064580 N5511CDss Consulting LLC · Omaha, NEBuilt 1979 · S/N 21063772 N5516CCarson Kirk · Dalhart, TXBuilt 1979 · S/N 21063774 N5517UKoegel John C · Flint, MIBuilt 1984 · S/N 21064897 N5523YSimmons Scott · Anchorage, AKBuilt 1981 · S/N 21064236 N5528AWarden Hutterian Brethren · Warden, WAS/N 21063482 N5531ASouther Field Aviation Inc · Americus, GAS/N 21063484 N5537CM G Aviation · Tyler, TXBuilt 1979 · S/N 21063785 N5538YTeton View Aircraft Leasing LLC · Grass Valley, CABuilt 1981 · S/N 21064241 N5549AGeoterra Inc · Eugene, ORBuilt 1979 · S/N 21063491 N5550YSteiner Paul R · Boerne, TXBuilt 1981 · S/N 21064245 N5555GSinton Frank J · Durango, COBuilt 1975 · S/N 21061039 N555RCCaron Robert M · Fort Pierce, FLBuilt 1976 · S/N 21061303 N555RYA-1 Windshield Inc · Rexburg, IDBuilt 1977 · S/N 21062146 N555SKJld Resources Management LLC · Helena, MTBuilt 1982 · S/N 21064728 N559TTMcdonald Aviation Mgt LLC · San Jose, CABuilt 1979 · S/N 21063335 N55RXJs Enterprises LLC · Clarinda, IABuilt 1981 · S/N 21064586 N562DGB2d LLC · Wickenburg, AZBuilt 1976 · S/N 21061684 N565RAN565ra LLC · Elbert, COBuilt 1977 · S/N 21062347 N567DTCenturion Aviation Inc · Kalispell, MTBuilt 1978 · S/N 21062856 N568HBKurreck Tim R · Caldwell, IDBuilt 1977 · S/N 21061864 N56DCAero Services Lc · Woods Cross, UTBuilt 1967 · S/N T210-0280 N5743JMidwest Aerial Photography · Galloway, OHBuilt 1970 · S/N P20600643 N5762JJonesco Acquisitions LLC · Bixby, OKBuilt 1971 · S/N 21059462 N5768JHaag Walter G · Fall City, WABuilt 1971 · S/N 21059468 N5771JRegistered aircraftBuilt 1971 · S/N 21059471 N57977Denney Dennis · New Port Richey, FLBuilt 1976 · S/N 21061475 N589JSWings West Consulting LLC · Mesa, AZBuilt 1980 · S/N U20606384

Back to AD 71-09-07 R1