Skip to content

Registered aircraft · 20,683

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-06-03-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-06-03-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-06-03-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-06-03-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-06-03-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-06-03-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.

N4265QParrish Aviation Flight Academy LLC · Southlake, TXS/N 17260165 N4266FCape Fear Aviation Maintenance LLC · Fayetteville, NCBuilt 1958 · S/N 46166 N4266QMaxwell James B · Lewiston, IDBuilt 1971 · S/N 17260166 N4267FValenzuela Kevin · Totowa, NJBuilt 1958 · S/N 46167 N4267QDhf LLC · Valentine, NEBuilt 1971 · S/N 17260167 N4269FPerkey Gilbert J Jr · Eagle Rock, VAS/N 46169 N4269LBussey Stuart · Lafayette, CABuilt 1966 · S/N 17254338 N426CPCivil Air Patrol · Montgomery, ALBuilt 2001 · S/N 172S8688 N426DLHawk30 Aviation LLC · Wilmington, DEBuilt 1981 · S/N 172RG0827 N426EPKentucky Airmotive Inc · Mount Sterling, KYBuilt 1998 · S/N 17280647 N426ESWeaver Corey E · Saline, MIBuilt 1997 · S/N 17280263 N426HLGiurtino Joel F · Spring Hill, FLBuilt 1977 · S/N 17269050 N426JGAero Flight School No7 LLC · Lincoln Park, NJBuilt 2008 · S/N 172S10862 N426LPAir Mates Flying Club Inc · Northfield, NJBuilt 1999 · S/N 172S8199 N426MCMagic Carpet LLC · Wilmington, DEBuilt 1971 · S/N 17260022 N426RBChristiansen Aviation LLC · Wilmington, DEBuilt 2011 · S/N 172S11134 N426SKBergstrom Aircraft Inc · Pasco, WABuilt 1979 · S/N 17273720 N4270LDavenport Sam · Gail, TXBuilt 1966 · S/N 17254339 N4270QReeves James C · Locust Grove, GABuilt 1971 · S/N 17260170 N4271FStevens George C · Lake Leelanau, MIBuilt 1958 · S/N 46171 N4271LRoberts David W · Arden, NCS/N 17254340 N4272FCayton John C · Cameron, MOS/N 46172 N4272LStechbart Kurt E · Glendora, CABuilt 1966 · S/N 17254341 N4273FVan Wychen James G · Warrens, WIBuilt 1958 · S/N 46173 N4273QSimmons Robert J · Justin, TXBuilt 1971 · S/N 17260173 N4274FAppalachian Bible College Inc · Mount Hope, WVS/N 46174 N4274QLjn Aircraft LLC · Jamestown, NYBuilt 1971 · S/N 17260174 N4275FG & M Associates LLC · Quitman, GAS/N 46175 N4275LBarney Jared L · Tully, NYBuilt 1966 · S/N 17254344 N4276QOjdrovich George · Steamboat Springs, COBuilt 1971 · S/N 17260176 N4277FMilitary And Civilian Aviation Heritage Foundation · Benton, PABuilt 1958 · S/N 46177 N4277QRawlins William David Sr · Martinez, GABuilt 1971 · S/N 17260177 N427CPCivil Air Patrol Inc · Maxwell Afb, ALBuilt 2001 · S/N 172S8689 N427CRAb Prop Plane II LLC · Metairie, LABuilt 2014 · S/N 172S11450 N427EPChristiansen Aviation LLC · Wilmington, DEBuilt 1998 · S/N 17280606 N427JGLigon Scott A · Florence, ALBuilt 1973 · S/N 17261688 N427KRDean Michael D · Montrose, CABuilt 2004 · S/N 172S9683 N4280LShellbourne Aviation LLC · Ormond Beach, FLBuilt 1966 · S/N 17254349 N4281FFour Winds Aviation LLC · Stigler, OKS/N 46181 N4281LKiger Aviation LLC · Corvallis, ORBuilt 1966 · S/N 17254350 N4281QMcdonald Air Services LLC · Saint Johns, MIBuilt 1971 · S/N 17260181 N4282FThomas Christopher D · Pacific Palisades, CABuilt 1958 · S/N 46182 N4282QShirley Walter Allen · Bullhead City, AZBuilt 1971 · S/N 17260182 N4283FMckee Jay R · Dixon, WYS/N 46183 N4283SHayes Timothy · Gray, MEBuilt 1974 · S/N 17263748 N4284FNolen Collin · Newman Lake, WABuilt 1958 · S/N 46184 N4284PEmpire Aviators LLC · Long Island City, NYS/N 17264088 N4285QShielded Holdings LLC · Katy, TXBuilt 1971 · S/N 17260185 N4287QMonmouth Area Flying Club · Lakewood, NJBuilt 1971 · S/N 17260187 N4288QN4288q LLC · Myrtle Beach, SCBuilt 1971 · S/N 17260188

Back to AD 90-06-03 R1