Registered aircraft · 13,518

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:99-05-13-R1-WD') OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:99-05-13-R1-WD') 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:99-05-13-R1-WD')
    OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:99-05-13-R1-WD')
  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:99-05-13-R1-WD')
  OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:99-05-13-R1-WD')
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.

N3815BPacifica LLC · Grand Junction, COS/N D-4088 N3815KShoemaker James W · Hilltop Lakes, TXBuilt 1980 · S/N CE-939 N3815PNorth Louisiana Aviation LLC · Mer Rouge, LABuilt 1981 · S/N E-1850 N38166S&P Airplane Sales · Branson West, MOBuilt 1981 · S/N TC-2371 N38168Jjj&S Aviation Corp · Brooklyn, NYBuilt 1981 · S/N E-1808 N3816NBailey James · Lewisburg, TNBuilt 1947 · S/N D-1045 N3816SKey Field Flyers LLC · Toomsuba, MSBuilt 1981 · S/N E-1806 N3816YDegregorio Dennis P · Tinley Park, ILBuilt 1981 · S/N M-2304 N38175Fhg Springbrook Corp · Wilmington, DEBuilt 1981 · S/N CE-940 N3817MGulf Skies LLC · Kalispell, MTBuilt 1981 · S/N EA-191 N3818ZRigney Mark E · Ponca City, OKBuilt 1981 · S/N WA-225 N38191Burgess Sheldon A · Raymond, MSBuilt 1981 · S/N M-2303 N38198Zero Mike LLC · Chattanooga, TNBuilt 1981 · S/N TC-2387 N3819BLucky 20 Gourmet And Adventure Club LLC · Syracuse, INS/N D-4079 N3819ZO'Rourke John P · Mobile, ALBuilt 1981 · S/N MC-750 N381CRSiemsen Randall R · Clovis, CABuilt 1976 · S/N E-875 N381FGSky West Aviation Inc Trustee · Albuquerque, NMS/N EA-249 N381SBettys Beech LLC · Conway, ARBuilt 1968 · S/N TE-629 N381TCShumate Frank T · Rockport, TXBuilt 1978 · S/N TK-83 N3820LFly A Twin LLC · Kirkland, WABuilt 1981 · S/N TJ-341 N3820MIsrael Howard A · Santa Monica, CABuilt 1981 · S/N TC-2372 N3822KPerry Park Investments Inc · Larkspur, COBuilt 1981 · S/N EA-192 N3822URegistration Pending · Stillwater, MNRegistration pendingBuilt 1981 · S/N D-10364 N3823AAndy Downs LLC · Langdon, NDBuilt 1981 · S/N EA-194 N3824RAbove All Aviation Inc · Santa Barbara, CABuilt 1980 · S/N MC-741 N3824XHirschauer Jeffrey · Spokane, WABuilt 1981 · S/N CE-941 N3824ZMoore Ricky J · Milton, KYBuilt 1980 · S/N MC-644 N3825MMckendry Scott P · Sanford, NCBuilt 1981 · S/N E-1813 N3826BVandusen Jason D · Grants Pass, ORBuilt 1955 · S/N D-4091 N3827QCobb Jeff B · Atlanta, GABuilt 1981 · S/N CE-942 N38282Zemetis Terence A · Meriden, CTBuilt 1981 · S/N E-1819 N3828NSallustio Eric · Lake Butler, FLBuilt 1981 · S/N E-1818 N3828XAmerican Flightscope Inc · Wilmington, DEBuilt 1981 · S/N TC-2374 N3829BIntermountain Valve Services Inc · Santaquin, UTBuilt 1955 · S/N D-4100 N3829XFerrari Martin · Centerville, OHBuilt 1981 · S/N M-2306 N382SHernandez Luis A · Longview, TXBuilt 1966 · S/N TE-166 N382TTWill Rittner · Sevierville, TNS/N G-143 N383Martis Valley Aviation LLC · Redwood City, CABuilt 1981 · S/N ME-388 N3836BThompson Aero Inc · Amana, IABuilt 1955 · S/N D-4107 N38384Baisden James Brett · Manassas, VABuilt 1981 · S/N WA-231 N3838BBarnes Patrick R · Berryton, KSBuilt 1955 · S/N D-4095 N38397Registered aircraftS/N WA-232 N3839JWheeler & Arey Pa · Waterville, MEBuilt 1981 · S/N MC-752 N3839LFlight School Of Gwinnett · Lawrenceville, GABuilt 1981 · S/N ME-397 N3839RChad Gunter Enterprises LLC · Albany, GABuilt 1981 · S/N EA-199 N3839SBailey Glenn K · Englewood, COBuilt 1981 · S/N EA-210 N383PLambe Clarence Jr · Kernersville, NCBuilt 2001 · S/N E-3430 N383TTWestwood Aircraft LLC · Asheville, NCBuilt 1999 · S/N E-3274 N3840BBata Anthony P · Fort Worth, TXS/N D-4110 N3840USomerset Aviation LLC · Gadsden, ALBuilt 1981 · S/N E-1821

Back to AD 99-05-13 R1 WD