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.

N2355EAce Of Spades Aviation LLC · Las Vegas, NVFirst renewal noticeBuilt 1978 · S/N 17271248 N2356Dunn Cole E · Florala, ALBuilt 1973 · S/N 17261946 N23566Sunrise Aviation Inc · Ormond Beach, FLBuilt 2005 · S/N 172S10097 N2356UPanko Jeffrey A · Lusby, MDS/N 17249956 N23581So Cal Leasing LLC · El Cajon, CABuilt 1998 · S/N 17280595 N2358EAircraft Guaranty Corp Trustee · Oklahoma City, OKS/N 17250725 N2358URegistration Pending · Cave Creek, AZRegistration pendingBuilt 1962 · S/N 17249958 N235CACivil Air Patrol · Maxwell Afb, ALBuilt 2023 · S/N 172S13084 N235EPEpic Aviation Inc · New Smyrna Beach, FLBuilt 2023 · S/N 172S13099 N235NYCivil Air Patrol Inc · Maxwell Afb, ALBuilt 1981 · S/N 17274911 N2363KJerk Assets LLC · Bakersfield, CABuilt 2001 · S/N 172S8817 N23673National Training 1 LLC · Wilmington, DEBuilt 1998 · S/N 17280563 N23675Atlanta Aviation Academy Inc · Lawrenceville, GABuilt 1999 · S/N 17280651 N23678Warner Donald R · Milford, MIBuilt 2007 · S/N 172S10591 N2368UPlehn Thomas R · Las Vegas, NVBuilt 1962 · S/N 17249968 N2369UMahoney Brandon M · Laurelville, OHS/N 17249969 N2369ZDhs Operations LLC · Wilmington, DEBuilt 1999 · S/N 17280658 N236AFAero Fisheries Inc · Fort Pierce, FLBuilt 1976 · S/N 17267726 N236DAFalany Curtis E · Tallahassee, FLBuilt 1966 · S/N 17254466 N236NYCivil Air Patrol Inc · Maxwell Afb, ALS/N 17268975 N236SP83l Ventures LLC · San Carlos, CABuilt 1999 · S/N 172S8213 N236TFChristiansen Aviation LLC · Wilmington, DEBuilt 2018 · S/N 172S12134 N2370FChristiansen Aviation LLC · Wilmington, DEBuilt 1998 · S/N 17280618 N2370JOrtega Aviation Services LLC · Wichita, KSBuilt 2005 · S/N 172S10100 N2370UWatts Keith R · Chapel Hill, TNBuilt 1963 · S/N 17249970 N2371ETmc Shooting Range Specialist Inc · Valencia, CAS/N 17271254 N2372USky View Aviation LLC · Lenoir, NCBuilt 1962 · S/N 17249972 N2373GCentral Iowa Aviation LLC · Ankeny, IABuilt 1998 · S/N 172S8073 N2373KReading Aero Club Inc · Reading, PABuilt 1999 · S/N 172S8074 N2373MChristiansen Aviation LLC · Wilmington, DEBuilt 2007 · S/N 172S10592 N2373UBeeline Aviation LLC · Austin, TXBuilt 1962 · S/N 17249973 N2373ZN3812q LLC · San Diego, CABuilt 1999 · S/N 172S8075 N2374EN2374e LLC A Series Of Aero Lease LLC · San Antonio, TXBuilt 1999 · S/N 17280716 N2374UEstes Kenneth · Benton, KSBuilt 1962 · S/N 17249974 N2376UHowell Rebecca Elizabeth · Elgin, TXBuilt 1962 · S/N 17249976 N2377EBeck Roger M Trustee · Goode, VABuilt 1978 · S/N 17271256 N23798Jet Air Inc · Iowa City, IABuilt 1998 · S/N 17280603 N2379UAlaska Aircraft Leasing LLC · Silverdale, WABuilt 1962 · S/N 17249979 N237DTBurque Sean Michael · New Braunfels, TXBuilt 1962 · S/N 17249862 N237SKAlf Ix LLC · Chicago, ILBuilt 2026 · S/N 172S13469 N237THWingsleasing LLC · Wichita, KSBuilt 2018 · S/N 172S12136 N2380AAircraft Engineering Inc · Eagle Lake, FLBuilt 1998 · S/N 17280617 N2381ZLeone Brighter Developments LLC · Carlsbad, CABuilt 2005 · S/N 17281276 N2382RTampa Bay Aviation Inc · Clearwater, FLBuilt 1999 · S/N 17280700 N2382UMrnm LLC · Albia, IABuilt 1963 · S/N 17249982 N2383GChristiansen Aviation LLC · Wilmington, DEBuilt 1999 · S/N 17280701 N23841Lam Capital Management LLC · Sheridan, WYBuilt 1999 · S/N 17280710 N2384LChristiansen Aviation LLC · Wilmington, DEBuilt 1999 · S/N 17280706 N2384UMoody Bible Institute Of Chicago · Spokane, WABuilt 1999 · S/N 17280708 N2385FAlpha Aviation Inc · Mount Vernon, WAS/N 17280714

Back to AD 90-06-03 R1