AD 81-18-04 R2

Registered aircraft · 81,733

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:81-18-04-R2')
    OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:81-18-04-R2')
  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.

N903EPEshuis Herman · Lake City, FLBuilt 2007 · S/N 267N903FCSkyborne Airline Academy Inc · Vero Beach, FLBuilt 2003 · S/N 2842175N903HWJackson Construction Services LLC · Wichita Falls, TXBuilt 1973 · S/N 32-7340068N903KCHawaii Pacific Aviation Inc · Kailua Kona, HIBuilt 1991 · S/N 1640N903NBEllis David E · Midlothian, TXBuilt 2009 · S/N 001N903NSAmerican Patrols Inc · Midland, TXBuilt 1976 · S/N 17267441N903SASunrise Aviation Inc · Ormond Beach, FLBuilt 1978 · S/N 15282468N903SDWernli Donald R · Perry, IABuilt 2003 · S/N 2437N903USSchneider Charles · Sioux Falls, SDBuilt 1966 · S/N 28-3068N90403Rintamaki Peter A · Meridian, IDBuilt 2007 · S/N R-001N90404Liberty University · Lynchburg, VABuilt 2010 · S/N 172S11064N9040JEllis James E Trustee · Harvard, MABuilt 1966 · S/N 28-3070N9040KGidden Aviation LLC · Katy, TXBuilt 1977 · S/N 28-7816186N9040PMcclure Jared · Claremore, OKBuilt 1988 · S/N 1152N90419Goodhue Clinton H · Sidney, MEBuilt 1967 · S/N R172-0254N9041DHamlin Ryan C · Naples, MEBuilt 1958 · S/N 22-6179N9041EGallagher Joshua Michael · Fromberg, MTBuilt 1977 · S/N 7073CN9042DGage Ricky D · Lewiston, IDBuilt 1958 · S/N 22-6180N9042HSt Pete Aviation Services LLC · St Petersburg, FLS/N 17265914N9042JRenfroe Charles R · Panama City, FLBuilt 1966 · S/N 28-3073N9042QTumbleweed Leasing Co Inc · Salt Lake City, UTBuilt 1976 · S/N 172-67996N9042YDupont Alexander Rene · East Taunton, MABuilt 1970 · S/N 18-8906N9043ATaylor David T · Caldwell, IDBuilt 1974 · S/N BH-120-302N9043HPinter Seth K · Abbotsford, WIBuilt 1975 · S/N 17265915N9043JHunter Lauchlin S Jr · Alexander City, ALS/N 28-3074N9043WKaufman William D · Shelburn, INBuilt 1965 · S/N 28-10635N9044DArctic Backcountry Flying Service LLC · Kotzebue, AKBuilt 1958 · S/N 18-6788N9044FFiggins Matthew J · Stewardson, ILBuilt 1976 · S/N 28-7790277N9044LAzzalin Giorgio · Jacksonville, FLBuilt 1970 · S/N 233-70N90450Air & Sea Leasing Inc · Cahokia, ILBuilt 1981 · S/N 0120N90459Maness William A · North Pole, AKBuilt 2008 · S/N 1-1N9045BEhg Flight LLC · Venice, CABuilt 2010 · S/N 172S11057N9045DLewis Elijah J · Luthersville, GABuilt 1958 · S/N 22-6183N9045JLandsgaard Theodore · Rosamond, CABuilt 1966 · S/N 28-3076N9045KHounslow Michael L · Rockville, MDBuilt 1977 · S/N 28-7890173N9045LSalter Christopher D · Elberta, ALBuilt 1970 · S/N 239-70N9045UFarabaugh William J · Ebensburg, PABuilt 2004 · S/N 723EN9045WDurflinger S A · Otterbein, INBuilt 1965 · S/N 28-10637N90462Manning Mark D · Wrenshall, MNBuilt 1959 · S/N 325N9046QDavis John A · Eau Claire, WIS/N 28-7125089N9046RDeoudes Demitrios N · Anchorage, AKBuilt 1947 · S/N 12-2311N9046WBalliet Barry F · Westampton, NJBuilt 1965 · S/N 28-10638N90478Right 360 · Santa Clara, CABuilt 2003 · S/N 2354N9047DHansen Bailey · Juneau, AKBuilt 1958 · S/N 22-6186N9047FOwens Todd C · Marietta, GABuilt 1977 · S/N 34N9047JHalajian Dominic M · Rogers, MNBuilt 1966 · S/N 28-3078N9047LDaniel Bryan G · Childress, TXS/N 217-70N9047YWeiss Michael F · Wyckoff, NJBuilt 1970 · S/N 18-8907N9048HGravesen Mark A · Kenmare, NDBuilt 1975 · S/N 17265917N90496Palmetto Aviation Of Charleston LLC · Johns Island, SCBuilt 1977 · S/N 32R-7780353
Back to AD 81-18-04 R2