Skip to content

Registered aircraft · 56,580

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:79-10-14-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:79-10-14-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:79-10-14-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:79-10-14-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:79-10-14-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:79-10-14-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.

N3143UTimuuu Inc · Alden, NYBuilt 1963 · S/N 18254543 N3143VWebb Hunter · Altonah, UTBuilt 1974 · S/N 15076401 N3144JChaffey Union Junior College District · Alta Loma, CABuilt 1966 · S/N 15065844 N3144QRichmond Brian · Rhome, TXBuilt 1967 · S/N 18258144 N3144RGivens Mickey M · Crosbyton, TXBuilt 1967 · S/N 18258544 N3144SMyers Dathan Dh · Port Angeles, WABuilt 1964 · S/N 18255644 N3144TKinsfather John D · Fowler, CABuilt 1967 · S/N 17700444 N3144VMike Smith Aviation International Inc · Napa, CABuilt 2002 · S/N 172S9123 N3145QN3145q LLC · Cave Creek, AZBuilt 1967 · S/N 18258145 N3145RSchnell Tyler C · Spearman, TXBuilt 1967 · S/N 18258545 N3145SCorriher Ronald R · Mount Ulla, NCBuilt 1964 · S/N 18255645 N3145YSiskiyou Aviation LLC · San Jose, CABuilt 1962 · S/N 18254145 N3146FMeyer Jackson · Soldotna, AKBuilt 1966 · S/N 18257246 N3146QJpw LLC · Red Lodge, MTBuilt 1967 · S/N 18258146 N3146RBednarik Edward L · Morgantown, PABuilt 1967 · S/N 18258546 N3146UAscend Aviation LLC · Post Falls, IDS/N 18254546 N3147CSchlutz Ivan F · Longmont, COBuilt 1954 · S/N 30946 N3147JRegistered aircraftS/N 15065847 N3147QBernbeck Alan R · Benton, KSBuilt 1967 · S/N 18258147 N3147TClinton Grant A · Portage Des Sioux, MOS/N 17700447 N3147XSuperior Golf Course Maintenance LLC · Plantation, FLBuilt 1966 · S/N 17255297 N3148CFreund Timothy P · Mesa, AZBuilt 1954 · S/N 30947 N3148JWoerle Edward R · Rossville, TNBuilt 1966 · S/N 15065848 N3148PSky Hi Aviation LLC · Wilmington, DEBuilt 1977 · S/N 210-61945 N3148RMyl High Flying Club LLC · Mccall, IDBuilt 1967 · S/N 18258548 N3148SHauser Family Flying LLC · Mount Pleasant, PABuilt 1964 · S/N 18255648 N3148TMiller John W · Bluffton, INBuilt 1967 · S/N 17700448 N3148VConnor Gavin · Owensboro, KYBuilt 1974 · S/N 15076402 N3148XJennings Dewey S · Springfield, MOBuilt 1966 · S/N 17255298 N3148YHernandez Alfonso C · Garland, TXBuilt 1962 · S/N 18254148 N3149AOlson Karl D · Fairbanks, AKBuilt 1953 · S/N 25793 N3149TShugart Fredrick William · Canfield, OHBuilt 1967 · S/N 17700449 N314ATBerlin Airlift Historical Foundation · Farmingdale, NJBuilt 1968 · S/N 337-1047 N314AVN1412v LLC · Manassas, VABuilt 1974 · S/N 17263557 N314BAComer Jacob · Troy, MOBuilt 1962 · S/N 18254547 N314BWCooper Matthew A · Seattle, WABuilt 1952 · S/N 25389 N314FRHawkeye Helicopter LLC · Lyndon, KSBuilt 1998 · S/N 18280260 N314GTYellow Jacket Flying Club Inc · Atlanta, GABuilt 1981 · S/N 17274774 N314LARaintree Aviation LLC · Mesa, AZBuilt 2013 · S/N 172S11285 N314MPTeristar LLC · Lewes, DEBuilt 1958 · S/N 51634 N314NFWillis Charlotte Y · Belleview, FLBuilt 1960 · S/N 52548 N314PYKahn William D · Weddington, NCBuilt 1971 · S/N 18260879 N314RARochester Air Center LLC · Canandaigua, NYBuilt 1998 · S/N 17280489 N314RSAcorn Mutual Flying Club Inc · Hershey, PABuilt 1977 · S/N 17269038 N314SOrem John Marshall · Shallowater, TXBuilt 1956 · S/N 33981 N314SAAeryn Innovations LLC · Dallas, TXBuilt 2003 · S/N 18281243 N314TTSappa Valley Construction LLC · Oberlin, KSBuilt 1961 · S/N 18253457 N3150DTransmountain Aviation Inc · Kasilof, AKBuilt 1955 · S/N 31948 N3150JKeown Kyle W · Saint Charles, MOBuilt 1966 · S/N 15065850 N3151ADavis William G · Mercer, MEBuilt 1953 · S/N 25795

Back to AD 79-10-14 R1