Skip to content

Registered aircraft · 930

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:76-14-07-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:76-14-07-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:76-14-07-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:76-14-07-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:76-14-07-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:76-14-07-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.

N1863FAndersen Dana K · Scappoose, ORS/N 21058763 N1864FSwensen Nathan E · Winnemucca, NVS/N 21058764 N1867FIcarus Aviators LLC · Canon City, COBuilt 1966 · S/N 21058767 N1869FRegistration Pending · Dublin, OHRegistration pendingBuilt 1966 · S/N 21058769 N186RDWayson Air LLC · Mount Auburn, IABuilt 1966 · S/N 21058761 N1870FWilliams Aviation LLC · Indianola, IAS/N 21058770 N1871FGorham Neil M · Memphis, TNBuilt 1966 · S/N 21058771 N1875FMcfadin T E · San Antonio, TXBuilt 1966 · S/N 21058775 N1877FHoots Kent B · Macon, GABuilt 1966 · S/N 21058777 N1879FKris Noone Air LLC · Wilmington, DES/N 21058779 N187MMSelf Aviation LLC · Hayden, IDBuilt 1965 · S/N 21058707 N1883FAnkeney Scott · Canyon, TXBuilt 1966 · S/N 21058783 N1887FHeadings Kevin · Echo, ORS/N 21058787 N1889FPiper Henry Burton Jr · Kingston, TNBuilt 1966 · S/N 21058789 N1892FPanagotacos George · Corona, CABuilt 1966 · S/N 21058792 N1893FKleeman Mark · Kearney, MOS/N 21058793 N18NFR D Aviation LLC · Phoenixville, PABuilt 1967 · S/N 21058903 N18PWPhenix LLC · Dayton, WABuilt 1963 · S/N 21058192 N198PBolski Dariusz · Rancho Cordova, CABuilt 1960 · S/N 57319 N198RPAircraft Guaranty Corp Trustee · Oklahoma City, OKBuilt 1976 · S/N 210-61063 N1LQStrydom Cornelis F · Liberal, KSBuilt 1966 · S/N T210-0148 N1YDBerg Bradley · Tulare, CABuilt 1968 · S/N 21059105 N200NMOrr Leroy A · Tonasket, WABuilt 1960 · S/N 57271 N205NBAirmotive Service LLC · Brigham City, UTBuilt 1962 · S/N 205-0151 N210ADUniplane Inc Trustee · Wilmington, DEBuilt 1967 · S/N 210-58835 N210AKMaxinkuckee Aviation LLC · Columbus, INS/N 21061627 N210APRegistration Pending · Wilmington, DERegistration pendingBuilt 1965 · S/N 21058713 N210ATTeeters David A · Salinas, CABuilt 1969 · S/N 21059186 N210AWJohnson Matt R · Fox Island, WABuilt 1964 · S/N 21058492 N210DFHampton Harvey E · Simms, MTBuilt 1968 · S/N T210-0397 N210DWBlomberg Nicholas R · Macon, MOBuilt 1967 · S/N 21058876 N210EBas Part Sales LLC · Greeley, COBuilt 1964 · S/N 21058365 N210EAFollis Allen J · San Tan Valley, AZBuilt 1962 · S/N 21057973 N210EGCenturion Aviation LLC · Nokesville, VAS/N 21059133 N210ETVroom Consulting Inc · Ithaca, NYBuilt 1968 · S/N 21059079 N210FCatron Stephen R · Kansas City, MOS/N T210-0244 N210GGWiegler Michael · Austin, TXBuilt 1966 · S/N 21058790 N210GNJackson Flying LLC · Siloam Springs, ARBuilt 1961 · S/N 21057803 N210GTTeufel Gregory W · Lake Stevens, WABuilt 1961 · S/N 21057590 N210JRowdy Mcbride Hunting Services LLC · Alpine, TXBuilt 1968 · S/N 21059076 N210JRSouthard Robert W · Elk City, OKBuilt 1959 · S/N 57017 N210KCFluid Media Inc · Moscow, IDS/N 21061595 N210KEKampel Thomas E · Wellsville, PAS/N 21058505 N210LDPurcell Darrell Ray · Yuma, AZBuilt 1968 · S/N 21059094 N210NBurton Stone LLC · Durango, COBuilt 1969 · S/N 21059102 N210NSNovember Sierra Aviation LLC · Oneill, NEBuilt 1960 · S/N 21057595 N210PEVan Dyke Gary D · Pleasant Grove, CABuilt 1969 · S/N 21059180 N210PRShaw Ronald V · Edmond, OKS/N 64883 N210RRBeasley Emmett C · Bixby, OKBuilt 1960 · S/N 57503 N210SCSpence C Jason · New Braunfels, TXBuilt 1967 · S/N 21058888

Back to AD 76-14-07 R2