Skip to content

Registered aircraft · 17,025

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:72-03-03-R3') OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:72-03-03-R3') 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:72-03-03-R3')
    OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:72-03-03-R3')
  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:72-03-03-R3')
  OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:72-03-03-R3')
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.

N150WTJenson Greg R · Pueblo, COS/N 15065949 N150WVBlack Star Aviation LLC · Round Rock, TXBuilt 1971 · S/N 15072848 N1510QOracle Aviation LLC · Omaha, NEBuilt 1971 · S/N 15072810 N1512QGroves Fenton A · Morrisville, NYBuilt 1971 · S/N 15072812 N1514QHudgens Andrew S · Lubbock, TXBuilt 1971 · S/N 15072814 N1515QPalm Springs Air Museum Inc · Palm Springs, CABuilt 1971 · S/N 15072815 N1516QToth John R · Concord, CABuilt 1970 · S/N 15072816 N15178Gill Robert S · Woodinville, WABuilt 1966 · S/N R172-0179 N1517UN1517u LLC · Mequon, WIBuilt 1969 · S/N 20700117 N1518QMidwest Aero Restorations Ltd · Danville, ILBuilt 1971 · S/N 15072818 N1518UN1518u LLC · Waukesha, WIS/N 20700118 N15194Mcgrath Kevin M · Cloquet, MNBuilt 1967 · S/N R172-0195 N1519QRuppert Thomas E · Fairbanks, AKBuilt 1971 · S/N 15072819 N151EGGadis Anthony J · Etiwanda, CABuilt 1973 · S/N 15075402 N151GWSale Reported · Avondale, COSale reported, pending cancellationS/N 15070186 N151KACook Christopher K · Wintersville, OHBuilt 1971 · S/N 15072494 N1521HHopkins John C Jr · Tallulah, LABuilt 1975 · S/N 177RG0698 N1523QKuharske Jeffrey · Groveland, FLS/N 15072823 N1524QAnderson Anton E · Loves Park, ILBuilt 1971 · S/N 15072824 N1525HKubasch Kevin M · Longville, MNBuilt 1975 · S/N 177RG0701 N1526HThompson Roy Dayton · Bulverde, TXBuilt 1975 · S/N 177RG0702 N1526QTurpin George · Maquoketa, IABuilt 1971 · S/N 15072826 N152MLBright Trevis Lee · Marion, INBuilt 1969 · S/N 15070431 N152PHahn Tacy W · Nevada City, CABuilt 1963 · S/N 18255080 N1534HCooley Norbert · Elkton, MDBuilt 1975 · S/N 177RG0709 N1535HStramer Todd Personal Representative · Hazelton, NDBuilt 1975 · S/N 177RG0710 N1539HAve Maria LLC · Batesville, INBuilt 1975 · S/N 177RG0713 N153AMMedford Daniel E · Lakeville, MNS/N 17702222 N153DACentral Virginia Aviation Inc · North Dinwiddie, VAS/N 15073786 N1540HFurtick Reginald D · Iuka, MSBuilt 1975 · S/N 177RG0714 N1541HAtkin Cris R · St George, UTBuilt 1975 · S/N 177RG0715 N1542HCessna N1542h LLC · Fond Du Lac, WIBuilt 1975 · S/N 177RG0716 N1544HBaugh Ashton C · Petal, MSBuilt 1975 · S/N 177RG0718 N1545GSaltzer Eric R · Somerton, AZBuilt 1966 · S/N T210-0208 N1546QInternational Air Services Inc Trustee · Carson City, NVBuilt 1971 · S/N 15072846 N1547QAndersen Cameron T · French Gulch, CABuilt 1971 · S/N 15072847 N1548HShrader Brian K · Marion, INBuilt 1975 · S/N 177RG0722 N154BCTen Knot Tailwind LLC · Mesa, AZBuilt 1969 · S/N 21059157 N154EFAdams Donald C · Garner, NCBuilt 1968 · S/N 21059089 N1552HLewis Daniel Bryce · Waller, TXBuilt 1975 · S/N 177RG0726 N1553HBuckner Robert M · Eufaula, OKBuilt 1975 · S/N 177RG0727 N1557HOpequon LLC · Vanderbilt, PABuilt 1975 · S/N 177RG0731 N1559HCardair Inc · Allentown, PABuilt 1975 · S/N 177RG0733 N155DJCorder Farms Aviation LLC · Mcarthur, CABuilt 1966 · S/N 18257851 N1560HFly North Of Known LLC · Aurora, ORBuilt 1975 · S/N 177RG0734 N1561HTorpey Richard T · Bay Shore, NYBuilt 1975 · S/N 177RG0735 N1561QWhisper Jet Aviation LLC · Scottsdale, AZS/N 15072861 N1562QFrontjes Richard J · Essexville, MIBuilt 1971 · S/N 15072862 N1563HSpokane Cardinal · Spokane Valley, WABuilt 1975 · S/N 177RG0737 N1565HSchornick Brad W · Oklahoma City, OKBuilt 1975 · S/N 177RG0739

Back to AD 72-03-03 R3