OpenAirDocs.org
AD 90-06-03 R1

Registered aircraft · 20,687

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-06-03-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-06-03-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.

N734SMFive Mcds LLC · Jupiter, FLBuilt 1977 · S/N 17269077N734SRJohnston Robert M · Bakersfield, CABuilt 1977 · S/N 17269081N734STLeading Edge Aviation Inc · Bend, ORBuilt 1977 · S/N 17269083N734SUBrown Melinda · Pax, WVBuilt 1977 · S/N 17269084N734SWSierra Sky Aviation LLC · Kalispell, MTBuilt 1977 · S/N 17269086N734SXMondo Beyondo Thrill Squadron · Pasadena, CABuilt 1977 · S/N 17269087N734SYBeck Roger M Trustee · Goode, VAS/N 17269088N734TJsta LLC · Sheridan, WYBuilt 1977 · S/N 17269138N734TAIronbound Aviation Inc · Bellingham, MABuilt 1977 · S/N 17269090N734TDDecolagem Aviation LLC · Woodbridge, VABuilt 1977 · S/N 17269093N734TEWhite Jeffrey M · Carlsbad, CABuilt 1977 · S/N 17269094N734TFHerman Grady B · Princeton, INBuilt 1977 · S/N 17269095N734TLLopez Jose A · Heath, TXBuilt 1977 · S/N 17269100N734TSMohle Darren H · Carlsbad, CAS/N 17269106N734TUPradhan Anis · Torrance, CABuilt 1977 · S/N 17269108N734TWFly Zone LLC · Wilmington, DEBuilt 1977 · S/N 17269110N734TXKusnierz Theodore T · Gansevoort, NYBuilt 1977 · S/N 17269111N734UAJorgensen Kathrine · Moscow, TNBuilt 1977 · S/N 17269114N734UEJupiter Flight Service And Investing LLC · Lithonia, GABuilt 1977 · S/N 17269118N734UFAlen Sergio Raul · Davie, FLFirst renewal noticeS/N 17269119N734UHSzymanski Collin A · Anchorage, AKS/N 17269121N734UL734ul LLC · Blaine, MNBuilt 1977 · S/N 17269124N734UMSweet Sunshine Produce Co LLC · Ocala, FLBuilt 1977 · S/N 17269125N734UPLee Randall Ross · Houston, TXS/N 17269127N734UQFuture Technologies Inc · Colonia, NJBuilt 1977 · S/N 17269128N734URKastle Todd Trustee · Gilroy, CAS/N 17269129N734USLowery Dwight W · Clayton, NCBuilt 1977 · S/N 17269130N734UTBlue Sky Aviation LLC · Menominee, MIBuilt 1977 · S/N 17269131N734UUPenn Aero LLC · Lewisburg, PABuilt 1977 · S/N 17269132N734UVCavu Flying Club · Wauwatosa, WIBuilt 1977 · S/N 17269133N734UWFisher Stephen C Trustee · Lamar, ARS/N 17269134N734UXJantz Carl R · Columbia, MOBuilt 1977 · S/N 17269135N734UYAg & Csv Inc · Pine Bush, NYBuilt 1977 · S/N 17269136N734UZDream Unthreatened LLC · San Luis Obispo, CABuilt 1977 · S/N 17269137N734VCNashville Skyscrapers LLC · Old Hickory, TNBuilt 1977 · S/N 17269140N734VEFlyby Aviation LLC · Logan, UTBuilt 1977 · S/N 17269142N734VNKcsi Aerial Patrol Inc · Bakersfield, CABuilt 1977 · S/N 17269150N734VPBooth Danielle M · Somis, CABuilt 1977 · S/N 17269151N734VQJprg Aviation Inc · Orlando, FLBuilt 1977 · S/N 17269152N734VTDestination Aviation LLC · Destin, FLBuilt 1977 · S/N 17269155N734VVSummit Flight Services LLC · Paden, OKBuilt 1977 · S/N 17269157N734VXRed Door Aviation LLC · Dover, DEBuilt 1977 · S/N 17269159N734VZTri Air Inc · Aulander, NCBuilt 1977 · S/N 17269161N734WBWedoaero LLC · Vale, NCS/N 17269163N734WFLewis Patrick K · El Dorado, ARS/N 17269167N734WKWagner James M · Hockessin, DEBuilt 1977 · S/N 17269171N734WLFlight Answers LLC · Miami Lakes, FLS/N 17269172N734WNBoerne Flight Options LLC · Boerne, TXBuilt 1977 · S/N 17269174N734WPLaps LLC · Elkhorn, WIBuilt 1977 · S/N 17269175N734WRSealy Michael Robert · Summerville, SCBuilt 1977 · S/N 17269177
Back to AD 90-06-03 R1