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.

N6016AHolt Amanda · Grangeville, IDS/N 28616 N6016RCosse Harold C · Vacaville, CABuilt 1965 · S/N 17253685 N6017ARidgeway Daniel M · Kalama, WAS/N 28617 N6017LAviation Training LLC · Wilmington, DEBuilt 2006 · S/N 172S10170 N6017NGood Dog Leasing LLC · Vienna, VABuilt 2006 · S/N 172S10171 N6018AKing Andrew O · Newport, MEBuilt 1956 · S/N 28618 N6018KChristiansen Aviation LLC · Wilmington, DEBuilt 2006 · S/N 172S10174 N6018ZWarner Aviation Co · Council Bluffs, IABuilt 2006 · S/N 172S10175 N6019AMitman John J · Florence, MTBuilt 1956 · S/N 28619 N6019VChristiansen Aviation LLC · Wilmington, DEBuilt 2006 · S/N 172S10177 N601LSM&G Aircraft Management LLC · Englewood, COBuilt 2022 · S/N 172S12853 N601PAMendenhall Michael L · Douglasville, GABuilt 1977 · S/N 17269030 N6020ADanielson Donald J · Walla Walla, WABuilt 1956 · S/N 28620 N6020RFly For Fun Aircraft LLC · Rockville, MDBuilt 1965 · S/N 17253689 N6021FB R S Leasing Inc · Wilmington, DEBuilt 2006 · S/N 172S10180 N6021KRegistration Pending · Grand Forks, NDRegistration pendingBuilt 2006 · S/N 172S10181 N6021RBechtold Richard · Broadlands, VABuilt 1966 · S/N 17253690 N6022RCunningham Gene Jr · Bristol, VABuilt 1965 · S/N 17253691 N6023SChristiansen Aviation LLC · Wilmington, DEBuilt 2006 · S/N 17281337 N6023VChristiansen Aviation LLC · Wilmington, DEBuilt 2006 · S/N 172S10198 N6024EDhs Operations LLC · Wilmington, DEBuilt 2006 · S/N 172S10200 N6024TDouglass Bruce · Conway, MABuilt 2006 · S/N 172S10202 N6025ACullen Aviation LLC · Lafayette, LABuilt 1956 · S/N 28625 N6026SPhoneix East Aviation LLC · Daytona Beach, FLBuilt 2006 · S/N 172S10206 N6026ZAerodynamic LLC · Aurora, ORBuilt 2006 · S/N 172S10208 N6027RHunt Ronald L · Crystal Lake, ILBuilt 1965 · S/N 17253696 N6027ZSpacely Space Sprockets LLC · Aurora, ORBuilt 2006 · S/N 172S10159 N6028AHafner Karl · Fulton, NYBuilt 1956 · S/N 28628 N6028YPuerto Rico Aircraft Leasing Corp · Ceiba, PRBuilt 2006 · S/N 172S10173 N6029AHofer Phillip · Choteau, MTBuilt 1956 · S/N 28629 N6029RLamb Stephen R · Myton, UTBuilt 1965 · S/N 17253698 N602EREmbry Riddle Aeronautical University Inc · Prescott, AZBuilt 2021 · S/N 172S12698 N602JYN13303 LLC · Miami, FLS/N 17262651 N602NDRainer Flight Service LLC · Renton, WABuilt 2012 · S/N 172S11253 N602TCSanderson Kimberly L · Swartz, LABuilt 2000 · S/N 172S8383 N602TLCoast Flight Training And Management Inc · San Diego, CABuilt 2008 · S/N 172S10736 N6031EHigh Exposure Inc · Wilmington, DEBuilt 1978 · S/N 17271984 N6031LRegistered aircraftBuilt 2006 · S/N 172S10188 N6031WWings Over Texas Holdings LLC · Denton, TXBuilt 2006 · S/N 172S10189 N60337Lewis University · Romeoville, ILBuilt 2006 · S/N 172S10192 N6033SSuburban Air Corp · Castro Valley, CABuilt 2006 · S/N 172S10191 N6034ATexas P M R Inc · Converse, TXBuilt 1956 · S/N 28634 N6034BFxe Flightcenter Corp · Fort Lauderdale, FLBuilt 2006 · S/N 172S10193 N6034DDuro Vincent · Highland, CABuilt 2006 · S/N 172S10195 N6034FToth Norman J · Spring Hill, FLBuilt 2006 · S/N 172S10196 N6035RWings Over Waxhaw Flying Club Inc · Waxhaw, NCBuilt 1965 · S/N 17253704 N60363Cumulus Aviation Services LLC · Port Orange, FLBuilt 2006 · S/N 172S10215 N6036RConte Perry · Stone Harbor, NJS/N 17253705 N6036YChristiansen Aviation LLC · Wilmington, DEBuilt 2006 · S/N 172S10213 N60372Above And Beyond Aviation LLC · Austin, TXBuilt 2006 · S/N 172S10216

Back to AD 90-06-03 R1