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.

N6880WRegistered aircraftBuilt 1965 · S/N 28-21036N6880ZMayes Brett R · Williams, CAS/N 25-2605N68810Air-Planes LLC · Soddy Daisy, TNBuilt 1978 · S/N 15282385N68812Avcorp Holdings Inc · Jackson, MIBuilt 1981 · S/N 15285339N68813Vogt Jeffrey D · Pleasant Grove, CAS/N 15282388N68814Spooner Wade G · Donalsonville, GABuilt 1978 · S/N 15282389N68815Skippy Aviation LLC · Bridgeport, PAS/N 15282390N68816Mirkovic Alex · Friendswood, TXBuilt 1978 · S/N 15282391N6881KTime 2 Fly LLC · Baldwinsville, NYBuilt 1979 · S/N 16-724N6881NMorris Michael R · Columbus, OHBuilt 1968 · S/N 680155N6881UElliott James C · Parker, COBuilt 1963 · S/N 2585N6881VCox Colin T · Harbinger, NCS/N 20-1168N6881WLewis Mark A · Ozark, ALBuilt 1965 · S/N 28-21037N68820Putz Aeroplanes LLC · Bryan, TXBuilt 1944 · S/N 75-5350N6882UHoecher Robert T · Anchorage, AKS/N 2586N68837Somes Jason · Newbury Park, CABuilt 1942 · S/N 75-8233N6883BSlagle Allen E · Newcastle, WYBuilt 1956 · S/N 18-5070N6883JRobbins John L · Crossville, TNS/N 28-7615387N6883KDrb Helicopters LLC · Klamath Falls, ORS/N 16-726N6883NAj Mooney LLC · Port Saint Lucie, FLBuilt 1968 · S/N 680128N6883SWebb Ronald G · Dickson, TNBuilt 1956 · S/N 680-407-83N6883VHubbell Carl · Crowley, TXBuilt 1975 · S/N 20-1170N6883ZFoster Gary L · Palmer, AKBuilt 1964 · S/N 18-8136N68840Federal Aerial Applicators LLC · Wilmington, DES/N 76-159N6884HWings Over Texas Holdings LLC · Denton, TXBuilt 1975 · S/N 17265625N6884JHbk Flyers LLC · Alton, ILBuilt 1976 · S/N 28-7690420N6884KWyatt Mary Ellen Personal Representative · Weirsdale, FLBuilt 1949 · S/N 16-728N6884NLutes Kent A · Tazewell, TNBuilt 1968 · S/N 680157N6884USheaffer Bruce R Jr · Lititz, PABuilt 1963 · S/N 2588N6884VVan Dyck Ryan G · Talent, ORS/N 20-1171N68857Wright Air Service Inc · Fairbanks, AKBuilt 1974 · S/N 1463N68858Betz Tim · Anchorage, AKBuilt 1973 · S/N 1464N6885HRasmussen Stewart · Santa Barbara, CABuilt 1975 · S/N 17265626N6885NPoskevich Douglas · Deland, FLBuilt 1968 · S/N 680158N6885UGranier Bernie C Trustee · Bandera, TXBuilt 1963 · S/N 2589N6885WMiller Andy D · Marana, AZS/N 28-21041N6886BOhmans Inc · Gillette, WYBuilt 1956 · S/N 18-5073N6886HParr Larry · Clarksville, TNBuilt 1975 · S/N 17265627N6886JFlanders David J · Madison, WIBuilt 1976 · S/N 28-7690421N6886NSibille Keith Curtis · Griffin, GABuilt 1968 · S/N 680129N6886UN6886u Inc · Tucson, AZBuilt 1963 · S/N 2590N6886WGregory Joshua L · Oxford, MSBuilt 1965 · S/N 28-21042N68874Hutchison Thomas L · Kimberly, IDBuilt 1974 · S/N 1707N6887NColton Frank Lasusa · Harrisburg, PABuilt 1968 · S/N 680159N6887UAce Aircraft Leasing Inc · Nazareth, PABuilt 1963 · S/N 2591N68882Tri-Gear Aviation LLC · Land O Lakes, FLS/N 1713N68883Baker Jack B · Naples, IDBuilt 1974 · S/N 1477N68884Barren Creek LLC · Mardela Springs, MDBuilt 1974 · S/N 1714N6888BVenell Farms Inc · Corvallis, ORBuilt 1956 · S/N 18-5076N6888DCenter Charles C · Wasilla, AKBuilt 2005 · S/N 101-1
Back to AD 90-04-06 R1