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.

N9904VStratus Aviation LLC DBA · Vacaville, CABuilt 1974 · S/N 17264553N9905FNew Horizon Aviation Inc · Warwick, RIBuilt 1997 · S/N 17280184N9905QCentral Air Service · Lewistown, MTBuilt 1975 · S/N 17265849N9906LRiseaero LLC · Florence, SCBuilt 1986 · S/N 17276647N9907QPlasco Designs Of Arkansas Inc · Texarkana, ARBuilt 1975 · S/N 17265851N9909QCk Aviation LLC · Charlestown, INBuilt 1975 · S/N 17265853N990BFlight Academy LLC · Van Nuys, CABuilt 1978 · S/N 17272059N990CPCivil Air Patrol Inc · Maxwell Afb, ALBuilt 1997 · S/N 17280256N99100Sterling Flight Training LLC · Jacksonville, FLBuilt 1985 · S/N 172-76401N99104Dury Aviation Services Inc · De Soto, ILBuilt 1985 · S/N 17276403N9910QTevebaugh Dennis J · Elkhart, KSBuilt 1975 · S/N 17265854N9911QAeronautical Technical Service Inc · Collierville, TNS/N 17265855N9912LCivil Air Patrol Inc · Maxwell Afb, ALBuilt 1986 · S/N 17276648N9912QKd Aviation LLC · Sheridan, WYBuilt 1975 · S/N 17265856N99141Airgo Inc · Centralia, ILBuilt 1985 · S/N 17276409N9914ESimica Charles A · Marietta, GABuilt 1979 · S/N 17272288N9914LFlex Air Holdings Inc · Manhattan, KSBuilt 1986 · S/N 17276649N9914QVictor Aviators Inc · Kernersville, NCBuilt 1975 · S/N 17265858N99157Hess Garrett J · Fullerton, CABuilt 1985 · S/N 17276412N9915BTaro Investment LLC · Doral, FLBuilt 1982 · S/N 172RG1078N99171Airlake Aero Inc · Lakeville, MNBuilt 1985 · S/N 17276414N9917QStill Flying LLC · Gibsland, LABuilt 1975 · S/N 17265861N9918EByrne Evan A · Mountain Lake Park, MDBuilt 1979 · S/N 17272289N9918FChristiansen Aviation LLC · Wilmington, DEBuilt 1997 · S/N 17280194N9918QCerqueira Luiz Fernando · Orem, UTBuilt 1975 · S/N 17265862N9919BPlane Fun Inc Tr Trustee · Snellville, GABuilt 1982 · S/N 172RG1080N9919QBlomstrom Andrew R · Oregon, WIBuilt 1975 · S/N 17265863N991NADatkuliak Michael C · Beallsville, OHBuilt 1965 · S/N 17253709N9920BSchultz Robert G · Baker, FLBuilt 1982 · S/N 172RG1081N9920VSkywarrior Flight Training Inc · Pensacola, FLBuilt 1974 · S/N 17264556N99243Wings Over Texas Holdings LLC · Denton, TXBuilt 1985 · S/N 17276418N9924BNatre Air II LLC · Tipton, INBuilt 1982 · S/N 172RG1082N9924QMy Way Aviation LLC · Weston, FLBuilt 1975 · S/N 17265868N9924VEdwards Kevin M · Grass Valley, CAS/N 17264558N99253Mitiguy Aviation LLC · Stow, MABuilt 1985 · S/N 17276421N9925QRoeder Cara R · Lake Charles, LABuilt 1975 · S/N 17265869N9925VGoodin Joshua W · Jacksonville, FLBuilt 1974 · S/N 17264559N99263Wings Over Texas Holdings LLC · Denton, TXBuilt 1985 · S/N 17276424N99265St Pete Aviation Services LLC · Saint Petersburg, FLBuilt 1985 · S/N 17276425N99273United States Air Force · Dover Afb, DEBuilt 1985 · S/N 17276427N9927QAndrus Shane · Pullman, WABuilt 1975 · S/N 17265871N9928QDavis John · Jackson, WYBuilt 1975 · S/N 17265872N99295Sky Warrior Flight Training Inc · Pensacola, FLBuilt 1985 · S/N 17276429N992CPCivil Air Patrol Inc · Maxwell Afb, ALBuilt 1997 · S/N 17280284N992VTVermont Flight Academy · South Burlington, VTBuilt 1998 · S/N 172S8043N992WWTss Flying Club Inc · Bethesda, MDBuilt 1999 · S/N 17280717N9931BLevin Lawrence W · Glencoe, ILFirst renewal noticeBuilt 1982 · S/N 172RG1084N9931EN9931e LLC · Phoenix, AZBuilt 1979 · S/N 17272291N9931QDexter Aero Club Inc · Stetson, MEBuilt 1975 · S/N 17265875N99329Tactical Integrated Training Soluctions LLC · San Antonio, TXBuilt 1985 · S/N 17276432
Back to AD 90-06-03 R1