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.

N5291SWilliams Scott H · Renton, WABuilt 1970 · S/N 28-26913N5291TGodin David M · Levant, MEBuilt 1959 · S/N 50553N5291WMaxxum Financial Group Inc · Destrehan, LABuilt 2002 · S/N 172S9234N52922Northwest Flyers Inc · Marianna, FLBuilt 1981 · S/N 17274635N52923Grinton Harry M · Arvada, COBuilt 1974 · S/N 18262955N5292EJam Three LLC · Saint George, UTBuilt 1978 · S/N 17271821N5292GSideline Services LLC · Pearland, TXBuilt 1965 · S/N 22515N5292KBates Field Aero Club Inc · Mobile, ALBuilt 1980 · S/N 17274048N5292NGoicoechea Mitchell Trustee · Elko, NVBuilt 1980 · S/N 18267624N5292PBrooksby Blake L · Pahrump, NVS/N 24-332N5292REss Adventures LLC · Damascus, ARBuilt 1974 · S/N 17263506N5292SVermilyea Paul E · Newton, KSBuilt 1970 · S/N 28-26923N52939Warwas Steven M · Yorktown, TXBuilt 1981 · S/N 17274641N5293BBas Part Sales LLC · Greeley, COBuilt 1996 · S/N 29-0080N5293GShamrock Aviation LLC · Seabrook, NHBuilt 1958 · S/N 22812N5293JWestsand Aviation LLC · Allegan, MIBuilt 1982 · S/N 414A0857N5293KBrooks Jimmy · O Fallon, ILS/N 17274049N5293SBullock Agency Inc · Saint Charles, ILBuilt 1970 · S/N 28-26841N5293XBaker Leasing LLC · Kotzebue, AKS/N U20605612N5294Brown Kevin Lee · Broseley, MOBuilt 1971 · S/N MC-94N52940Schickner Michael J · Mesa, AZBuilt 1974 · S/N 18262964N52942Origer Deborah F · Albany, ORS/N 18262966N5294GHainline Charles H · Friendswood, TXBuilt 1951 · S/N 22166N5294LBreidenbach Amy K · Onalaska, WIBuilt 1968 · S/N 28-4595N5294RRemus Stephen J · Warren, MIBuilt 1974 · S/N 17263508N5294WSonneborn Arthur Aaron · East Leroy, MIBuilt 2003 · S/N 17281186N5294XCarrigan Roy K · Oak Grove, MNS/N 2220N52950Jin Jin Aviation LLC · Anchorage, AKBuilt 1981 · S/N 17274642N52953Pacific Fleet Aviation LLC · Rochester, NYBuilt 1981 · S/N 17274644N52957Koch Eric C · Charlotte, NCBuilt 1974 · S/N 18262973N52959Triple T Metal Corp · Bryantsville, KYBuilt 1974 · S/N 18262975N5295ETimbers Flying Club · West Branch, MIFirst renewal noticeBuilt 1978 · S/N 17271824N5295GJohnston Robert · Hico, TXBuilt 1979 · S/N 17273559N5295NHillcrest Emergency Physicans Inc · Tulsa, OKBuilt 1980 · S/N 18267627N5295SAlzarqa Saleh A · Fairfax, VABuilt 1970 · S/N 28-26941N52963Union Movie Works LLC · Sacramento, CABuilt 1974 · S/N 18262976N5296AHobot LLC · Springdale, ARBuilt 1985 · S/N P21000847N5296BRobertson Ca · Phoenix, AZS/N 1158N5296GTobul James R · Jackson, WYBuilt 1951 · S/N 21616N5296KTorres Ruben E · Toa Alta, PRBuilt 1980 · S/N 17274050N5296PFlanagan Robert Howard · Willows, CABuilt 1958 · S/N 24-337N5296RB&R Aircraft LLC · Wadsworth, OHBuilt 1974 · S/N 17263510N5296TGq Aviation LLC · Cherry Hill, NJBuilt 1972 · S/N 34-7250244N5296UMeyers Karl F · Tucson, AZRegistration revokedBuilt 1964 · S/N U206-0296N5296ZSouthern Sky LLC · Henderson, NVBuilt 2002 · S/N 172S9241N5297BHughes Shaman · Cedaredge, COBuilt 1956 · S/N 1159N5297EAtd Pilot Training LLC · Kansas City, MOBuilt 2002 · S/N 172S9242N5297GChristiansen Aviation LLC · Wilmington, DEBuilt 2002 · S/N 172S9243N5297LIndulgences Inc · Putnam Valley, NYBuilt 1968 · S/N 28-4599N5297PMoretti Anthony · Deming, NMBuilt 1958 · S/N 24-338
Back to AD 2007-04-19 R1