AD 90-04-06 R1

Registered aircraft · 68,377

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
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-04-06-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-04-06-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.

N601LANicely Juan · Mount Vernon, KYS/N 1473N601LPMorford Leon R · Rockford, ILS/N 6-5230N601MLMahaney James C · Ellijay, GABuilt 2004 · S/N 6-3375N601PAMendenhall Michael L · Douglasville, GABuilt 1977 · S/N 17269030N601PSCastle Rock Services LLC · Helena, MTBuilt 1999 · S/N 60001N601RDPichon Dean M · Essex, VTBuilt 2001 · S/N 2981N601RKNorthampton Aeronautics Inc · Northampton, MABuilt 1978 · S/N ME-71N601RVFly Right LLC · Reno, NVBuilt 2003 · S/N 60325N601TGKenmore Crew Leasing Inc · Bellingham, WAS/N 28R-7235214N601TMMims Edwin T · Murphy, NCBuilt 2008 · S/N 6-5545N601VLBeal Mark E · Northwood, IABuilt 2009 · S/N 6-5093N601VSJireh Wings LLC · Las Vegas, NVS/N 2036LN601VVBilodeau Allan M · Lakeland, FLBuilt 2017 · S/N 6-5610N601XSSpainhower Craig · Lakeland, FLBuilt 2008 · S/N 6-5096N6020DDufreche David S · Sanger, TXBuilt 1956 · S/N 22-4673N6020LJenkins David B · Hemet, CABuilt 1972 · S/N AA5-0120N6020PClark Katherine A · Spring, TXBuilt 1979 · S/N MC-653N6020QN6020q LLC · Jensen Beach, FLBuilt 1965 · S/N 3231N6020WBritton Jeffrey A · Accident, MDBuilt 1964 · S/N 28-20020N60216Shore Stephen A · Elkin, NCBuilt 1940 · S/N 75-280N6021QR&L Aviation Inc · Philadelphia, PAS/N 3232N6021WA&C Aviation LLC · Lawrenceville, GABuilt 1964 · S/N 28-20021N6021ZAerial Banners Inc · Pembroke Pines, FLS/N 25-25N6022LIrving Donald J · Deland, FLBuilt 1975 · S/N 0712N6022PRegistered aircraftBuilt 1959 · S/N 24-1117N6022SAhlberg Merick D · Eagle River, AKBuilt 1979 · S/N M-2156N6022WDelgado Mario J · Baldwin Park, CAS/N M-2153N6023DBusta Daniel N · Los Angeles, CABuilt 1956 · S/N 22-4676N6023XSytsma Douglas A · Canton, MIBuilt 1960 · S/N 1611N60244Ace Of Spades Aviation LLC · Las Vegas, NVBuilt 1978 · S/N ME-130N6024DPunt Matthew L · Wasilla, AKBuilt 1956 · S/N 22-4677N6024WWhite Pelican LLC · Union City, TNBuilt 1964 · S/N 28-20024N60250Camelot Aviation LLC · Wilmington, DEBuilt 1969 · S/N 15070171N6025WSocal Flights LLC · Simi Valley, CAS/N 28-20025N6026GAce Pdr LLC · Lewisville, TXS/N 2073N6026LDolan Kathleen M · Sunnyside, WABuilt 1972 · S/N AA5-0126N6026QKosmata Charles C · Mcpherson, KSBuilt 1965 · S/N 3234N6027DSnyder Logan J · Wasilla, AKBuilt 1956 · S/N 22-4680N6027QBergh Robert P · Hammett, IDS/N 874N6028CPopejoy Gregory M · Sacramento, CABuilt 1954 · S/N 137-4N6028QSky Partners LLC · Sylacauga, ALBuilt 1965 · S/N 875N6028XHarnagel Duard R · Scottsdale, AZBuilt 1960 · S/N 1618N6029DRonnie L Tremain · Sherwood, ORBuilt 1956 · S/N 22-4682N6029QHill John T · Saint Augustine, FLBuilt 1965 · S/N 3235N6029WWalsh Robert D · Somerset, CABuilt 1964 · S/N 28-20029N602AKimberlin Lisa · San Francisco, CABuilt 1951 · S/N 22-5N602CBWray David A · Louisville, KYS/N 446-18-1830N602EPJones Theodore R · Prospect, KYBuilt 2002 · S/N 70382N602FLRoberts David R · West Newton, MABuilt 1971 · S/N 28-7125476N602FTFlorida Institute Of Technology · Melbourne, FLBuilt 1977 · S/N 28-7716056
Back to AD 90-04-06 R1