OpenAirDocs.org
AD 2003-22-07 R1

Registered aircraft · 177

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:2003-22-07-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:2003-22-07-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.

N100BYFirst Flight Aviation LLC · Boerne, TXBuilt 1984 · S/N 1565 S.A.N100CFRed Rooster Rentals LLC · Alto, GABuilt 1972 · S/N 229N100KEPm Leasing Inc · Perris, CABuilt 1974 · S/N 313SAN100MUWakaya Services Inc · Dover, DEBuilt 1980 · S/N 793SAN1164FRegistration Pending · Dickerson, MDRegistration pendingS/N 1562 S.A.N117HGobuyair LLC · Flint, MIBuilt 1979 · S/N 751SAN11SJSouthland Metroplex Aviation LLC · Colleyville, TXBuilt 1973 · S/N 285N122CKAircraft Guaranty Corp Trustee · Oklahoma City, OKBuilt 1978 · S/N 374SAN122MAPanda Aviation Inc · Washougal, WAS/N 207N124PCSaxton Leasing Inc · Plymouth, MIS/N 438SAN129DWDelta Whiskey Ltd · Staten Island, NYBuilt 1974 · S/N 653N130MS3b Leasing LLC · Fairhope, ALS/N 750SAN13YSAir 1st Aviation Companies Inc · Aiken, SCBuilt 1976 · S/N 694N140CPColumbia Asset Trust Corp Trustee · Wichita, KSS/N 362SAN143JACosco & Associates Inc · Crestview, FLBuilt 1974 · S/N 324N145FSSolitaire LLC · Appleton, WIS/N 437 S.AN14VLJpw Aviation LLC · Clarksdale, MSBuilt 1981 · S/N 1514SAN15TCStax Holdings LLC · Hot Springs, ARBuilt 1976 · S/N 692N15TRNorthwest Aviation LLC · Fargo, NDBuilt 1981 · S/N 446 S.A.N165MARegistered aircraftBuilt 1975 · S/N 326N1727SN1727s LLC · Calhoun, GAS/N 1504 S.A.N175CAAir 1st Aviation Companies Of Oklahoma Inc · Tulsa, OKBuilt 1979 · S/N 736SAN178SBCrawford Setrige · Santa Barbara, CAS/N 435 S.A.N17HGMu2 LLC · Lewes, DEBuilt 1981 · S/N 1510 S.A.N18BFCenter For Endodontics Inc · Fresno, CABuilt 1969 · S/N 173N193AABig Mountain Aviation Inc · Whitefish, MTBuilt 1979 · S/N 741SAN196MAStef Air LLC · Muscle Shoals, ALBuilt 1979 · S/N 764 S.A.N200GCameron Global Strategies LLC · Springboro, OHBuilt 1981 · S/N 452 S.A.N2100TJ R Aero Leasing Inc · Lawrence, KSBuilt 1969 · S/N 182N216CDLandry Camile J · Baton Rouge, LABuilt 1974 · S/N 323N219MAJa1 Aviation LLC · Sedan, KSBuilt 1981 · S/N 440 S.A.N21HPExcalibur Enterprises LLC · Gainesville, VABuilt 1977 · S/N 357SAN220JSMt Mgt LLC · Missoula, MTBuilt 1981 · S/N 1545 S.A.N222FAExpress Aviation Management LLC · Dover, DES/N 714SAN228WPRegistration Pending · Wichita, KSRegistration pendingBuilt 1972 · S/N 228N22MKLhb Aviation LLC · Williamsburg, VAS/N 375SAN22MZChurchill Robert Jr · Wasilla, AKS/N 158N24WCDach Capital Holdings Inc · Newark, DES/N 705SAN252BWMotor Vanguard LLC · Campbellsville, KYBuilt 1980 · S/N 423 S.A.N261WBNorthern Jet Sales LLC · Port Saint Lucie, FLBuilt 1975 · S/N 330N271TWBaker Aviation LLC · Dover, DES/N 734 S.A.N272MCN272mc Leasing LLC · South Jordan, UTBuilt 1973 · S/N 272N281MAWife Approved LLC · Torrance, CABuilt 1973 · S/N 261N28AFEumundi Trading Co Inc · Wilmington, DES/N 241N2RAFlying Mu2 LLC · Reno, NVS/N 366SAN2RRMelocity Air LLC · Saint Petersburg, FLBuilt 1981 · S/N 454 S.A.N305DSAircraft Operations LLC · Portland, ORBuilt 1975 · S/N 328N30MAWilson Construction Delaware Corp · Ketchum, IDBuilt 1978 · S/N 371SAN316ENFayetteville Aviation Inc · Fayetteville, TNBuilt 1976 · S/N 349SAN321GMWestern News & Info Inc · Prescott Valley, AZBuilt 1981 · S/N 1505 SA
Back to AD 2003-22-07 R1