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.

N49325Qualiair LLC Trustee · MichelstadtBuilt 1985 · S/N 1031N49328Air Puerto Rico Corp · Aguadilla, PRFirst renewal noticeBuilt 1979 · S/N 15283448N4932JDunlap Aviation Inc · Dunlap, ILBuilt 1968 · S/N 28R-30653N4932ZWilczynski John J · Lake Village, INBuilt 1961 · S/N 22-8524N49330Cjw Hydrodynamics Inc · Fresno, TXBuilt 1986 · S/N 1035N49331Plane Fun Inc Tr Trustee · Snellville, GAS/N 1038N49332Blue Eagle Pitts LLC · Tempe, AZS/N 1039N49336Krieger Heinz Friedrich · FrenkendorfS/N 1045N49337Herrmann Ralf D · DahlemBuilt 1986 · S/N 1046N49338Bakker Matthew G · Ellington, CTBuilt 1986 · S/N 1044N49339Goble John H · Cresson, TXBuilt 1987 · S/N 1047N4933JRegistration Pending · Columbia, SCRegistration pending, pending cancellationBuilt 1968 · S/N 28R-30654N4933LSouthall Charles B · Amelia, OHS/N 28-4301N4933ZSale Reported · Clio, MISale reportedS/N 22-8525N49340Butler Tracey D · Buckley, WABuilt 1987 · S/N 1048N49341Dale Michael E · Murrieta, CABuilt 1979 · S/N 15283449N49343Schroeder James Conrad · Redondo Beach, CABuilt 1987 · S/N 1050N49347Bryant Otto LLC · Conway, ARBuilt 1991 · S/N 1190N49348Benner Tristen · Opheim, MTBuilt 1991 · S/N 1194N49349Rankin Ty · Amarillo, TXBuilt 1991 · S/N 1196N4934FAffordale Aviation Corp · Moriches, NYBuilt 1976 · S/N 28-7715082N4934LFlyboys LLC · Orange, VABuilt 1967 · S/N 28-4302N49353Skye Equipment LLC · Asheboro, NCBuilt 1992 · S/N 1217N49354Staple Three Sheep Co · Midwest, WYBuilt 1991 · S/N 1199N49357Miller Blaine Nathan · Brooks, GABuilt 1992 · S/N 1223N4935GKip'S Flying Service LLC · Bankston, ALBuilt 1979 · S/N 17273482N4935LCurnutt Aviation LLC · Fort Stockton, TXBuilt 1968 · S/N 28-5127N49362Schubert Paul · Raleigh, NCBuilt 1992 · S/N 1221N49363Back Country Aviation LLC · Kalispell, MTBuilt 1993 · S/N 1234N49365Mcdonald Ryan James · Chelan, WAS/N 1250N49366Kellogg John H · Skaneateles, NYBuilt 1994 · S/N 1257N4936LBluse James · Bethlehem, GABuilt 1967 · S/N 28-4304N4936ZDomeyer Daylen K · Cincinnati, OHS/N 22-8528N49370Powell Weston G · Washoe Valley, NVBuilt 1994 · S/N 1273N49371Hebert Max C · Hartstown, PABuilt 1995 · S/N 1277N49372Walker Scott E · Fort Collins, COBuilt 1995 · S/N 1284N4937FRegistered aircraftBuilt 1976 · S/N 28-7790075N4937GInternational Air Services Inc Trustee · Carson City, NVBuilt 1979 · S/N 17273484N4937PMorcom Aviation Services Inc · Everett, WABuilt 1981 · S/N 15284849N49387Old Aire LLC · Bellingham, WAS/N 5-1493N4938HAir Poueir LLC · Amarillo, TXBuilt 1979 · S/N 15284033N4939LNorcross Tracy D · Saint Joseph, MOBuilt 1967 · S/N 28-4309N4939VFlorida Keys Flight Academy LLC · Marathon, FLBuilt 1980 · S/N 172RG0420N493BTRegistration Pending · Deltona, FLRegistration pendingBuilt 1975 · S/N 17702318N493CKTaylor Mark Steven · Goshen, OHBuilt 2012 · S/N 493N493DSDelaware State University · Dover, DEBuilt 1983 · S/N 28-8416011N493DWWayman Daniel M · Medford, ORBuilt 2005 · S/N 126N493FLPalmenteri Louis J · Rhome, TXS/N 28-7125308N493GCClayton Neil K · Oviedo, FLFirst renewal noticeBuilt 2007 · S/N 493N493JLPhoenix Flyers Inc · Mesa, AZBuilt 1998 · S/N 18280138
Back to AD 90-04-06 R1