Skip to content

Registered aircraft · 40,471

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-03-R2') 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-03-R2') 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-03-R2')
    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-03-R2')
  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-03-R2')
  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-03-R2')
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.

N7859GAviators LLC · Casco, WIBuilt 1970 · S/N 17259559 N7859NNls Real Estate LLC · Irving, TXBuilt 1969 · S/N 28-5317 N785ASA S Flight Academy LLC · Lantana, FLBuilt 1974 · S/N 17262954 N785DKFoxes Asset Group LLC · Caddo Mills, TXBuilt 1980 · S/N M-2250 N785ELRegistration Pending · Sekiu, WARegistration pendingBuilt 1985 · S/N 2026 N785RMJesnet Aviation LLC · Sanford, FLBuilt 1986 · S/N 28-8616057 N78603Beaufort Flight Training LLC · Beaufort, SCBuilt 1968 · S/N 17257682 N78606Brook Trout Properties LLC DBA · Kalamazoo, MIBuilt 1968 · S/N 17257684 N7860GRoberts Timothy J Jr · Taylor, TXBuilt 1970 · S/N 17259560 N7860NLindsay Construction LLC · Fernandina Beach, FLBuilt 1968 · S/N 28-5318 N7860WRed Rock Flying School LLC · Mesa, AZBuilt 1964 · S/N 28-1881 N7861DBarnes Rebecca · Anchorage, AKBuilt 1957 · S/N 18-6010 N7861EDoyle Vic L · Two Buttes, COBuilt 1959 · S/N 17661 N7861GHamilton William D · Lynnwood, WABuilt 1970 · S/N 17259561 N7861PSparks James R · Maxwelton, WVBuilt 1962 · S/N 24-3085 N7861WComer Christopher C · Randleman, NCBuilt 1964 · S/N 28-1882 N78622Copeland David Craig Aka · Jackson, GABuilt 1968 · S/N 17257689 N78623Laurel Highlands Aeronautical Academy · Latrobe, PABuilt 1968 · S/N 17257690 N78624Dewing Matthew S · Rome, PABuilt 1968 · S/N 17257691 N78626Ycm Solutions Inc · Mechanicsville, VABuilt 1968 · S/N 17257693 N78628Milot John M · Germansville, PABuilt 1968 · S/N 17257694 N7862GBogue Rodney J · Warner Robins, GABuilt 1970 · S/N 17259562 N7862NMontero Joseph A · Spring Hill, FLBuilt 1969 · S/N 28-5319 N7862PScenic Mountain Air Inc · Moose Pass, AKBuilt 1962 · S/N 18-7873 N7863DStevenson Ben L · Talkeetna, AKS/N 18-6012 N7863WBauer Thomas M · Fairfield, PABuilt 1964 · S/N 28-1884 N78640Glasheen Sean T · Bethel, AKS/N 17257698 N78642Little Falls Pilots Assn Inc · Nisswa, MNBuilt 1968 · S/N 17257699 N78647Twj Aviation 1 LLC · Jacksonville, FLS/N 17257702 N7864GSale Reported · Griffin, GASale reportedBuilt 1970 · S/N 17259564 N78650Quad Cities Aero LLC · Bettendorf, IABuilt 1968 · S/N 17257704 N78651N78651 LLC · Williamsburg, VABuilt 1968 · S/N 17257705 N78652Manning And Sons Property LLC · Summerville, SCBuilt 1968 · S/N 17257706 N78657Miller David C · Michigan City, INBuilt 1968 · S/N 17257707 N7865DLrh Equipment LLC · Pendleton, ORBuilt 1957 · S/N 18-6014 N7865NWalkup Gerald L · Novato, CABuilt 1969 · S/N 28-5322 N7865VGalmor Bobby Don · Shamrock, TXS/N 2828 N78663Klein Mark P · Ellsworth, KSBuilt 1968 · S/N 17257709 N78668Ames Jimmy M · Collinsville, OKBuilt 1968 · S/N 17257710 N7866GSurfside Seaplane Training LLC · Lino Lakes, MNBuilt 1970 · S/N 17259566 N7866WWiger Theodore L · Falcon Heights, MNBuilt 1964 · S/N 28-1887 N7866ZTucker Stanley J Trustee · Kiowa, KSBuilt 1963 · S/N 15059966 N78672Yount Lawrence F · Shelton, WABuilt 1968 · S/N 17257713 N7867HJenkins Joe C · Wyoming, DEBuilt 1946 · S/N 12-770 N7867WGilmore John J · San Carlos, CABuilt 1964 · S/N 28-1888 N78681Airflyte LLC · Granby, CTBuilt 1968 · S/N 17257718 N7868DAustin Vernon · Decatur, ALBuilt 1957 · S/N 18-6022 N7868VFagan Lawrence G Jr · Hudson Oaks, TXBuilt 1964 · S/N 2831 N78695Mac Electric LLC · White House, TNBuilt 1968 · S/N 17257723 N7869DThorn Scott E · Eagle River, AKBuilt 1957 · S/N 18-6024

Back to AD 80-04-03 R2