AD 2007-04-19 R1

Registered aircraft · 108,434

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:2007-04-19-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:2007-04-19-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.

N5599DSale Reported · Merritt Island, FLSale reportedBuilt 1957 · S/N D-5131N5599KDayton Walter S · Napa, CAS/N R18200922N5599PAd Ventures LLC · Camden, DEBuilt 1989 · S/N CE-1344N5599QFerraro Christopher · Croydon, PABuilt 1965 · S/N 2990N5599WPhoenix Aviation LLC · Claremore, OKBuilt 1962 · S/N 28-736N559AKBurton John · Nacogdoches, TXS/N 18258213N559BDBiggs Aviation LLC · Decatur, INBuilt 2004 · S/N 1470N559DBRundle James R · Sparks, NVBuilt 1969 · S/N 18260178N559DDRobinson Helicopter Co Inc · Torrance, CAS/N 3299N559ESeitan Eduard · Chicago, ILS/N 28-3248N559FLSandlak David J · Zephyrhills, FLBuilt 1971 · S/N 28-7125400N559JPNelson Scott E · Whispering Pines, NCBuilt 1978 · S/N 32R-7885276N559JTOrian Dillon R · Malibu, CABuilt 1960 · S/N 27-286N559KMRegistered aircraftBuilt 1982 · S/N 18268187N559MANorwood Kenneth Trustee · Rogers, ARBuilt 2000 · S/N 3246159N559MCBkjm LLC · Blanchard, OKBuilt 1978 · S/N 18503479N559MKBadawi Aviation LLC · Orlando, FLBuilt 1979 · S/N ME170N559PTracy Theodore W · West Chester, OHBuilt 2007 · S/N 317N559PDCrocker Donald E · Eagle, IDBuilt 2015 · S/N 91817N559PUSkyborne Airline Academy Inc · Vero Beach, FLBuilt 2000 · S/N 2842096N559RKRegistration Pending · Sheridan, WYRegistration pendingBuilt 1999 · S/N 0559N559RVBrady Norman M · Port Orange, FLBuilt 2009 · S/N 90978N559SP1.2 Gpa LLC · Rapid City, SDBuilt 2000 · S/N 172S8410N559TSuperbird Icc LLC · Mitchell, SDBuilt 1961 · S/N TC-108N559TJHangar 22 LLC · Watkinsville, GABuilt 2000 · S/N 18280852N559TTMcdonald Aviation Mgt LLC · San Jose, CABuilt 1979 · S/N 21063335N55ABAllan Michael D · Forney, TXBuilt 1974 · S/N 310R0038N55ADSchrage Rodney L · Steamboat Springs, COBuilt 1977 · S/N 1006N55AEFreer Lawrence C III · Puyallup, WABuilt 1966 · S/N TE-84N55AFRegistration Pending · Terre Haute, INRegistration pendingS/N 32-864N55AGAircraft Guaranty Corp Trustee · Oklahoma City, OKBuilt 1965 · S/N 30-804N55AJJudge Andrew L · Pinecrest, FLBuilt 1998 · S/N DMO 413N55AUWallner Chris R · Petaluma, CABuilt 2003 · S/N 60537N55AVFood Service Installations Inc · Vancouver, WAS/N 41889N55AXWhite Drew C · Granbury, TXBuilt 1964 · S/N 185-0723N55BFrankel Cary S · Harrison, NYBuilt 1979 · S/N 310R1830N55BCMcconnell Bert J · Hudson, OHBuilt 2003 · S/N 60360N55BNInternational Air Services Inc Trustee · Carson City, NVBuilt 1973 · S/N TC-1572N55BTWeyl George Randolph Jr · Bigfork, MTS/N 101N55BUBlue Side Up LLC · Oxford, CTBuilt 1978 · S/N TC-2138N55CBBrown Gary M · Sioux City, IABuilt 1958 · S/N D-5714N55CDNy Properties LLC · Greenwood, SCBuilt 1963 · S/N D-7273N55CGWick James · Canon City, COBuilt 1964 · S/N 21058434N55CMCamille Ventures LLC · Odessa, TXBuilt 1973 · S/N 4140423N55CNBaron 55cn LLC · Haltom City, TXBuilt 1964 · S/N TC-601N55CPCharli Papa LLC · Clovis, NMBuilt 1965 · S/N 18256550N55CRUltrapure Air LLC · Setauket, NYBuilt 1997 · S/N 392N55CVCavu LLC · Charleston, WVBuilt 1977 · S/N TE-1114N55CYBonneville Aero Works LLC · Greenville, SCBuilt 1961 · S/N 24-2674N55CZHall William · Boynton Beach, FLBuilt 1976 · S/N TC-1932
Back to AD 2007-04-19 R1