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.

N9038DJones Michael D · Eagle River, AKBuilt 1958 · S/N 22-6176N9038FGrupp Wayne · Wayne, ILBuilt 2006 · S/N 1N9038HPeterson Todd B · Cameron Park, CABuilt 1975 · S/N 17265912N9038KNorthwest Aviation LLC · Gig Harbor, WABuilt 1977 · S/N 28-7816185N9038YRodriguez Juan M · Grass Valley, CABuilt 1983 · S/N FM2N90392Parsons Walter E · Clinton, NCS/N 406N9039LBowman Eagles Inc · Louisville, KYBuilt 1970 · S/N 767-70N903CPCivil Air Patrol Inc · Maxwell Afb, ALBuilt 1999 · S/N 172S8327N903DRCrosgrove Shawn R · Riverton, UTBuilt 2013 · S/N 82372N903EESkywest Leasing Inc · St George, UTBuilt 1999 · S/N 2843229N903EPEshuis Herman · Lake City, FLBuilt 2007 · S/N 267N903FCSkyborne Airline Academy Inc · Vero Beach, FLBuilt 2003 · S/N 2842175N903KCHawaii Pacific Aviation Inc · Kailua Kona, HIBuilt 1991 · S/N 1640N903KTGarnier Brent A · Fairbanks, AKBuilt 1961 · S/N 22-8882N903NBEllis 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-001N9040JEllis 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-6179N90426Faulkner Linda W Trustee · Ooltewah, TNBuilt 1947 · S/N 47359N9042DGage 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-3073N9042NSeabee Heaven LLC · Lexington, SCBuilt 1947 · S/N 275N9042QTumbleweed 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-3074N9043TBlair Helicopter Service Inc · Lemoore, CABuilt 1975 · S/N CCI74-10N9044DArctic 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-70N9044THendrickson Flying Service Inc · Rochelle, ILBuilt 1975 · S/N CCI75-1N90450Air & Sea Leasing Inc · Cahokia, ILBuilt 1981 · S/N 0120N90459Maness William A · North Pole, AKBuilt 2008 · S/N 1-1N9045DLewis 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-70N9045TScotts Helicopter Service Inc · Le Sueur, MNBuilt 1975 · S/N CCI-75-2N9045UFarabaugh William J · Ebensburg, PABuilt 2004 · S/N 723EN90462Manning Mark D · Wrenshall, MNBuilt 1959 · S/N 325N9046QDavis John A · Eau Claire, WIS/N 28-7125089
Back to AD 90-04-06 R1