Skip to content

Registered aircraft · 56,578

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.

N11454Wausau Flying Service Inc · Wausau, WIBuilt 1973 · S/N 15075434 N1145FGurke George J · Anchorage, AKBuilt 1975 · S/N 18502757 N11460Kalmar Peter · Suquamish, WABuilt 1973 · S/N 15075439 N1146FLarson Larry D · Sargeant, MNBuilt 1966 · S/N 17254741 N1146MMitchell Kenneth A · Uniontown, PABuilt 1972 · S/N 33701446 N11476Shannon Kenneth H · Washington, DCBuilt 1975 · S/N 17702340 N11479Lucky Duck Aviation LLC · Palm City, FLBuilt 1973 · S/N 15075450 N1147FParker Robert M · Hurst, TXBuilt 1966 · S/N 17254742 N1147VRegistration Pending · Moore, OKRegistration pendingBuilt 1976 · S/N R1722122 N11485Foster Harold · Natchitoches, LABuilt 1973 · S/N 15075453 N11488Cooker Keith P · Greenville, SCBuilt 1973 · S/N 15075456 N1148DBohl Howard M · Temecula, CABuilt 1951 · S/N 15711 N1148FReed Roger · Lebanon, KYBuilt 1966 · S/N 17254743 N11491Jamieson Donald R · Condon, ORS/N 15075458 N11492Mccroan James H · Altha, FLBuilt 1973 · S/N 15075459 N11493Wajih Al Habbal · Simi Valley, CABuilt 1973 · S/N 15075460 N1149911499 LLC · Oklahoma City, OKS/N 15075464 N1149FLemery Aaron D · Chattaroy, WAS/N 17254744 N114AGRlc Aviation LLC · Ansted, WVBuilt 1979 · S/N U20604674 N114CZMinnesota Department Of Public Safety · Saint Paul, MNBuilt 1981 · S/N 18267892 N114FAJprg Aviation Inc · Orlando, FLBuilt 1978 · S/N 17271720 N114FBFly Appleton LLC · Appleton, WIBuilt 2005 · S/N 172S9811 N114VKKennedy Virgil C DBA · San Marcos, TXBuilt 2001 · S/N 172S8695 N114WPUniversal Aviators Academy Inc · El Monte, CABuilt 1976 · S/N 17267603 N11500Semmes James · El Centro, CABuilt 1975 · S/N 17702342 N11501Erickson Kirk E · Warroad, MNBuilt 1973 · S/N 15075466 N11506Fidk Inc · Warrenton, VABuilt 1975 · S/N 17702343 N11507Strickland Jed B · Bald Knob, ARBuilt 1973 · S/N 15075472 N1150DFlight Time Pathways · Forest Lake, MNBuilt 1951 · S/N 15713 N1150LNida Kevin R · Santa Paula, CAS/N 15073274 N1150YHoffman Anthony J · Rathdrum, IDBuilt 1962 · S/N 15059550 N11510Falls Aero Inc · Great Falls, MTBuilt 1973 · S/N 15075473 N11513Erickson Tristan Scott · Port Townsend, WABuilt 1973 · S/N 15075475 N11514Kickstart Aviation LLC · Mayfield, KYBuilt 1974 · S/N 15075476 N11517Grier Robert M · Deland, FLS/N 15075479 N11519Kap Title Inc · Tucker, GABuilt 1973 · S/N 15075481 N1151BOrtiz Daniel · Edinburg, TXBuilt 1973 · S/N 15075478 N1151DWelborn Mark G · Boonville, NCBuilt 1951 · S/N 15714 N1151YCraigmyle William R · Cooperstown, NYBuilt 1962 · S/N 15059551 N11527Red Oak Commuter LLC · Red Oak, IABuilt 1973 · S/N 15075489 N11528Streeter Derek · Guilford, CTBuilt 1973 · S/N 15075490 N11529Registration Pending · Mattituck, NYRegistration pendingBuilt 1973 · S/N 15075491 N1152MRst Aviation LLC · Vero Beach, FLBuilt 1970 · S/N 17259452 N1152VGolden Eagle Consulting LLC · Williston, NDS/N R1722123 N1152ZRainier Flight Service LLC · Renton, WABuilt 2006 · S/N 172S10339 N11531Ireland Lois Trustee · Herndon, VAS/N 15075493 N11533Neal Robert J · Martinsville, INBuilt 1973 · S/N 15075495 N11534Litzau Melissa · Lake Lillian, MNS/N 15075496 N11538Fallon James R · Chestnut Hill, MABuilt 1973 · S/N 15075500 N1153DCarbonaro Joseph J Jr · Lexington Park, MDBuilt 1951 · S/N 15716

Back to AD 79-10-14 R1