Skip to content

Registered aircraft · 68,375

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:90-04-06-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:90-04-06-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:90-04-06-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:90-04-06-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:90-04-06-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:90-04-06-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.

N34764York Aviators LLC · York, PABuilt 1973 · S/N 17701990 N34766Robbins Paul A · Nacogdoches, TXS/N 17701991 N34767Tschida Thomas R · Mendota Heights, MNBuilt 1973 · S/N 17701992 N3476XChristy Parker Consulting LLC · Wake Forest, NCBuilt 1966 · S/N 3419 N34770Gustin Brian K · Camdenton, MOBuilt 1973 · S/N 17701994 N34772Mlaskoch Air LLC · Willow River, MNBuilt 1973 · S/N 17701996 N34774Dunn Gregory Scott · Wooster, OHBuilt 1973 · S/N 17701998 N34777Trautmann Glenn K · Highlands Ranch, COBuilt 1973 · S/N 17702000 N3477EMorey Airplane Co Inc · Middleton, WIBuilt 1978 · S/N 17271563 N3477KToles Richard O · Wolcott, NYBuilt 1967 · S/N 28-23572 N3477MCapella LLC · Parkville, MOBuilt 1978 · S/N 28-7890305 N3477XCoulter Jack E · Chapel Hill, NCBuilt 1966 · S/N 3420 N34787Baker Herman L · Austin, TXBuilt 1973 · S/N 17702003 N3478AVanmeter Ted A · Pleasanton, KSS/N 22-1747 N3478KYarber Brandon Tate · Cleveland, TNBuilt 1967 · S/N 28-23573 N3478TGuzowski Richard G · Haydenville, MABuilt 1968 · S/N 17700778 N3478XCleveland Andrew D · Vancouver, WABuilt 1966 · S/N 1152 N34794Schmidt Gary L · Afton, MNBuilt 1973 · S/N 17702005 N34795Fox Business Advisors LLC · Mesa, AZBuilt 1974 · S/N 17702006 N34796Masters David R · Troy, KSBuilt 1973 · S/N 17702007 N3479TRobbins Derick Mitchell Robbins · Freeport, FLBuilt 1968 · S/N 17700779 N3479WMccurdy Robert Kelly · Glendale, AZBuilt 2007 · S/N 47011T N3479XFrontier Land & Cattle LLC · Ozark, MOBuilt 1966 · S/N 1153 N3479ZPhegley James R · Carlisle, INBuilt 1960 · S/N 18-7308 N347ACHarkal Enterprises · Des Moines, IABuilt 1998 · S/N 1371-98 N347BGBowling Green Flight Center LLC · Bowling Green, OHBuilt 2023 · S/N 2881652 N347CHAce Flight Center · St Thomas, VIBuilt 1974 · S/N 17263661 N347DProfessional Training Aircraft LLC · Wilmington, DEBuilt 2016 · S/N 2843840 N347DMSpivey Ricky S · Samson, ALBuilt 1997 · S/N 21803 N347ECallahan Kevin Michael · Des Moines, WABuilt 2011 · S/N 72189 N347GDNye Brian M · Independence, ORBuilt 2002 · S/N 23851 N347GWAllen Air LLC · Creola, ALBuilt 1966 · S/N 28-3651 N347MKNorth Star Aviation · Mankato, MNBuilt 2020 · S/N 2881417 N347RAAdamson Matthew C · Sherwood, ARBuilt 1978 · S/N 3100 N347RPRegistration Pending · Daytona Beach, FLRegistration pending, canceledS/N 28-571 N347STGraber Joel C · Collins, MSBuilt 2015 · S/N 0001 N347WGMt Aircraft LLC · Port Orange, FLBuilt 1968 · S/N 17256883 N34807Wiese Marcus G · Shady Shores, TXBuilt 1976 · S/N 177RG1014 N34808Barber Jeffrey A · Blaine, MNBuilt 1973 · S/N 17702016 N34809Grassmyer Richard M · Salem, INBuilt 1973 · S/N 17702017 N3480K3480k LLC · Waycross, GABuilt 1967 · S/N 28-23575 N3480MMegli Mike O · Dillingham, AKBuilt 1947 · S/N 12-2326 N3480TMoffatt Thomas O Jr · Diberville, MSBuilt 1968 · S/N 17700780 N3480XLorenzi Mark E · Lancaster, OHBuilt 1966 · S/N 1154 N34813Max Gs LLC · Wilmington, DEBuilt 1973 · S/N 17702020 N34816Clark Tal O · Hudson, COBuilt 1973 · S/N 17702022 N34818Rosenberger Mark W · West Columbia, SCBuilt 1973 · S/N 17702023 N34819Giles Forrest D · Springtown, TXBuilt 1941 · S/N 921 N3481MFabry Sean R · Anchorage, AKBuilt 1947 · S/N 12-2327 N3481TEstes Kenneth · Portland, ORS/N 17700781

Back to AD 90-04-06 R1