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.

N54634Savannah Airplane Venture LLC · Myrtle Beach, SCBuilt 1981 · S/N 17275017 N54635Memphis Navy Flying Club · Millington, TNBuilt 1981 · S/N 17275018 N5463JMachado Joe L · Tucson, AZBuilt 1980 · S/N 17273804 N5463KRick Aviation Inc · Newport News, VABuilt 1980 · S/N 17274129 N5463TFrazier Isaiah V · Blue River, WIBuilt 1964 · S/N 17251363 N54646Jordao Isabella C · Oklaunion, TXBuilt 1981 · S/N 17275022 N5464DJprg Aviation Inc · Orlando, FLBuilt 1979 · S/N 17272576 N5464KTrend Vector Aviation International Inc · Barrigada, GUBuilt 1980 · S/N 17274130 N5464TJackson Tyler H · Kittery, MEBuilt 1964 · S/N 17251364 N5465KMonroe Pilots Association LLC · Monroe, NCBuilt 1980 · S/N 17274131 N5465RHaffley And Ruiz LLC · Waco, TXBuilt 1965 · S/N 17253023 N54661Executive Flyers Inc · Sacramento, CABuilt 1981 · S/N 17275028 N54663Colorado Northwestern Community College · Rangely, COBuilt 1981 · S/N 17275029 N5466D5466 Delta LLC · Costa Mesa, CAFirst renewal noticeBuilt 1979 · S/N 17272577 N5466THildebrant Virginia Fay · Fall City, WABuilt 1964 · S/N 17251366 N54678Aero Association Of Caltech Inc · Pasadena, CABuilt 1981 · S/N 17275034 N5467RCarter Roy T · Shepherdsville, KYBuilt 1965 · S/N 17253026 N5467TRegistered aircraftBuilt 1964 · S/N 17251367 N54680Yanagida Kazuaki · Norco, CABuilt 1981 · S/N 17275035 N5468HPrjc Properties LLC · Vonore, TNS/N 17265456 N5468RCw Arborists Ltd · Killingworth, CTBuilt 1965 · S/N 17253027 N5469KAviation Specialists Inc · Apison, TNBuilt 1980 · S/N 17274135 N546ASouthern Illinois University · Murphysboro, ILBuilt 2011 · S/N 17281594 N546EREmbry Riddle Aeronautical University Inc · Prescott, AZBuilt 2026 · S/N 172S13538 N546MCLeaseair LLC · Wilmington, DEBuilt 2000 · S/N 172S8376 N546NDSpartan Education LLC · Tulsa, OKBuilt 2010 · S/N 172S11045 N5470KSkye Aircraft LLC · Deland, FLBuilt 1980 · S/N 17274136 N5470TLesnick Robert E · Charlotte, NCBuilt 1964 · S/N 17251370 N54715Apt Aero LLC · Port Angeles, WABuilt 1981 · S/N 17275038 N5471RGq Aviation LLC · Cherry Hill, NJBuilt 1965 · S/N 17253031 N5471TWiesen Michael J · Waldo, FLBuilt 1964 · S/N 17251371 N54728Vig Cheryl J · Opal, SDS/N 17275039 N5472KHayes Aviation LLC · New Smyrna Beach, FLS/N 17274138 N5472RAnderson Craig D · Mission Viejo, CABuilt 1974 · S/N 17263544 N54733Gofastpilots LLC · Roswell, NMBuilt 1981 · S/N 17275042 N54734Southern Arkansas University Tech · Camden, ARS/N 17275043 N54739Skylens LLC · Hammond, LABuilt 1981 · S/N 17275045 N5473DN1705r Inc · Cobb, CABuilt 1979 · S/N 17272579 N5473RRotormate LLC · Royse City, TXBuilt 1965 · S/N 17253034 N54744Suncoast Aviation Of Swfl LLC · Fort Myers, FLBuilt 1981 · S/N 17275047 N5474KBarr Air Partrol LLC · Mesquite, TXS/N 17274140 N5474RLeone Thomas A · Winchester, VABuilt 1965 · S/N 17253035 N5474TTisdell Branden L · Bear, DEBuilt 1964 · S/N 17251374 N54752Aerosync LLC · Miami, FLBuilt 1981 · S/N 17275048 N5475HRouth Frank D · Marion, NCBuilt 1975 · S/N 17265459 N5475KAnisoptera LLC · Dallas, TXBuilt 1980 · S/N 17274141 N5475REllerbee William B · Dothan, ALBuilt 1965 · S/N 17253037 N5477TRegistration Pending · Anchorage, AKRegistration pendingBuilt 1964 · S/N 17251377 N54781Kingsky Flight Academy LLC · Lakeland, FLBuilt 1981 · S/N 17275051 N5478RNorcal Flight Center LLC · Lincoln, CABuilt 1965 · S/N 17253041

Back to AD 90-06-03 R1