Registered aircraft · 20,687

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.

N8275BVixie James G · Milton Freewater, ORBuilt 1957 · S/N 36075 N8275XEvans C David II · Elkhart, INBuilt 1961 · S/N 17248775 N8276BHermens Stanley G · Wallowa, ORS/N 36076 N8276ESkyview Aviation LLC · Tracy, CABuilt 1979 · S/N 17272163 N8276LFly Time Aviation LLC · San Tan Valley, AZBuilt 1967 · S/N 17256476 N8277BRyder Clifford J · Massapequa, NYBuilt 1957 · S/N 36077 N8277LSillers Kim O · Sault Sainte Marie, MIBuilt 1967 · S/N 17256477 N8277UEdgewood Farms LLC · Groveland, NYBuilt 1964 · S/N 17252177 N8278EEquinoxx Flight Systems LLC · Lawrenceville, GABuilt 1979 · S/N 17272165 N8278UMattison Alan B · Petaluma, CABuilt 1964 · S/N 17252178 N8278XDepew Gerald R · Oak Ridge, TNBuilt 1961 · S/N 17248778 N8279EHull Farms Inc · Blythe, CABuilt 1979 · S/N 17272166 N827BWWhitby Aviation Inc · Athol, IDS/N 172S9841 N827EREmbry Riddle Aeronautical University · Daytona Beach, FLBuilt 2022 · S/N 172S12832 N827ESAtp Aircraft 1 LLC · Wilmington, DEBuilt 2013 · S/N 172S11280 N827KSPlanelease LLC · Venice, CABuilt 1999 · S/N 17280793 N827MAPs N827ma LLC · Green Bay, WIBuilt 2001 · S/N 17281015 N827PAJa Flight Services LLC · Sugar Grove, ILBuilt 2006 · S/N 172S10155 N8280BSea Coast Aviation LLC · Conway, SCBuilt 1957 · S/N 36080 N8280XRegistration Pending · Archer Lodge, NCRegistration pendingBuilt 1961 · S/N 17248780 N8281EAir Plains Services Corp · Wellington, KSBuilt 1979 · S/N 17272168 N8281LSliwinski Kellyn E · Anchorage, AKBuilt 1967 · S/N 17256481 N8281UHersch Richard E · Arlington, WAS/N 17252181 N8281XStull Carl · Phoenix, AZBuilt 1961 · S/N 17248781 N8282BAmyx Hiram R · Liberty, TXBuilt 1957 · S/N 36082 N8283LChapin Devon S · Oxford, CTS/N 17256483 N8283UThede Dondi I · Marshall, WIBuilt 1964 · S/N 17252183 N8283XWinfrey Walter A · Auburn, CABuilt 1961 · S/N 17248783 N8284LMaxwell Barton W Jr · Crawfordsville, INBuilt 1967 · S/N 17256484 N8285EJames G Loy General Contractor Inc · Punta Gorda, FLBuilt 1979 · S/N 17272171 N8285UDel Martin Lp · Spring, TXBuilt 1964 · S/N 17252185 N8285XBerntsen Bradley T Trustee · Apple Valley, MNBuilt 1961 · S/N 17248785 N8286EPreston Richard R Trustee · Albuquerque, NMBuilt 1979 · S/N 17272172 N8286LKyle John M · Wheeling, WVBuilt 1967 · S/N 17256486 N8287LShirk Matthew · Auburn, INBuilt 1967 · S/N 17256487 N8287XMckeever Jesse M · Indio, CABuilt 1961 · S/N 17248787 N8288EGomez Cierra D · Jasper, ALS/N 17272174 N8288XLantana Beach Flying Club · West Palm Beach, FLBuilt 1961 · S/N 17248788 N8289BGodfrey Brian T · Waupaca, WIBuilt 1957 · S/N 36089 N8289LFaust Stanley J · Nashua, NHBuilt 1967 · S/N 17256489 N8289UPrice William B · Lamar, SCBuilt 1964 · S/N 17252189 N828BMChristiansen Aviation LLC · Wilmington, DEBuilt 1997 · S/N 17280134 N828CFChristiansen Aviation LLC · Wilmington, DEBuilt 1998 · S/N 17280326 N828EREmbry Riddle Aeronautical University · Daytona Beach, FLBuilt 2022 · S/N 172S12833 N828FGRidgeline Assets LLC · Wilmington, DEBuilt 2023 · S/N 172S13076 N828FSPerformance Aircraft Sales Inc · Lincoln, NEBuilt 1999 · S/N 17280794 N828LPFlying Twenties Inc · San Jose, CABuilt 2001 · S/N 172S8828 N828PKElizabeth City State University · Elizabeth City, NCBuilt 2020 · S/N 172S12596 N828SPVista Aviation Inc · Pacoima, CABuilt 2001 · S/N 172S8741 N828WWMaranatha Insurance Services Inc · Rancho Cucamonga, CABuilt 2016 · S/N 172S11730

Back to AD 90-06-03 R1