Registered aircraft · 4,242

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

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:89-24-01-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:89-24-01-R1') ORDER BY n_number

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:89-24-01-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:89-24-01-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.

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:89-24-01-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:89-24-01-R1')
ORDER BY n_number

Run it at the DuckDB prompt, or in any tool that reads Parquet over HTTPS. More ways to query the release are on Use the data.

N7JNB & K Steel & Supply Inc · Ogden, UTBuilt 2000 · S/N EA-663 N7LTRobertson Cameron Lee · Las Vegas, NVS/N 21060936 N7LVBas Part Sales LLC · Greeley, COBuilt 1980 · S/N P21000506 N7MFBarger Christopher H Trustee · Mesa, AZBuilt 1980 · S/N P21000583 N7UBWhite James V · Prescott, AZBuilt 1976 · S/N 21061593 N800BAN8vv Inc · Corpus Christi, TXBuilt 1981 · S/N 414A0667 N800FUKing Air 3 Au LLC · Ozark, MOBuilt 1978 · S/N 21062792 N800JCThomas Bonner Enterprises LLC · Lubbock, TXBuilt 1979 · S/N TK-90 N800KWVenture Air Solutions Inc · Opa Locka, FLBuilt 1976 · S/N 402B1063 N801DCMalibu Queen LLC · Portola Valley, CABuilt 1987 · S/N 46-08053 N802MCRunaway Plane LLC · Oklahoma City, OKBuilt 1980 · S/N 335-0044 N802MSMarotta Scientific Controls Inc · Montville, NJBuilt 1983 · S/N 21064780 N8036TPaysse John G · Hanford, CABuilt 1980 · S/N EA-150 N8052MEcho Romeo LLC · Stamford, CTBuilt 1977 · S/N 21062031 N805JCBig Sky Baron Lc · Missoula, MTBuilt 1980 · S/N TJ-253 N805PRValiair Lc Trustee · Casper, WYBuilt 1985 · S/N 414A1206 N8067UPalmer Eric E · Tucson, AZBuilt 1992 · S/N EA-536 N8068QCreative Consulting Partners LLC · Fargo, NDBuilt 1974 · S/N 414-0503 N8079ZParker Larry E Jr · Lumber Bridge, NCBuilt 1992 · S/N EA-538 N807WSInter Island Freight LLC · Deerfield Beach, FLBuilt 1968 · S/N 4010300 N8081RCook Marvin R · Portales, NMBuilt 1969 · S/N D-8994 N8085QWes Hughes Corp · Waldron, KSBuilt 1974 · S/N 414-0506 N808LCHulsey Michael · Prescott, AZBuilt 1980 · S/N TJ-319 N808TWVa Office Of Emergency Service LLC · Hampton, VABuilt 1977 · S/N 340A0304 N8091QKhag Aviation Inc · Woodbridge, NJFirst renewal noticeBuilt 1973 · S/N 402B0369 N80CRRdp Construction LLC · Sitka, AKBuilt 1980 · S/N U20605548 N80GWSnyder Michael P · Las Vegas, NVBuilt 1974 · S/N 21060425 N80LMBarnwell John Randel · Conroe, TXBuilt 1979 · S/N TJ-216 N80MTMeloche Michael S Trustee · Hamilton, MTBuilt 1979 · S/N U20605467 N80PVRamos Investments Lp · Montgomery, TXBuilt 1977 · S/N 414-0963 N80SGFerland Henry L III · Vidalia, GABuilt 1980 · S/N 21064014 N80TZHuron Aviation Services LLC · Alpena, MIBuilt 1984 · S/N TJ-469 N80ZZKenmore Crew Leasing Owner Trustee · Bellingham, WABuilt 1984 · S/N 46-8408061 N810BWHyannis Air Service Inc · Hyannis, MABuilt 1980 · S/N 402C0279 N8115GRamble On LLC · Amarillo, TXBuilt 1993 · S/N EA-552 N811MASale Reported · Newberg, ORSale reportedBuilt 1976 · S/N TJ-75 N8129GJohnson Richard A Trustee · Chandler, AZBuilt 1971 · S/N 21059429 N812SRVantage Point Northwest Aviation LLC · Sheridan, WYBuilt 1979 · S/N 414A0326 N812VLa Plane LLC · Fort Thomas, AZBuilt 1972 · S/N 340-0157 N8130LPerfect 10 Roofing · Billings, MTS/N 21060617 N8130RGaines Robert G · Howell, MIBuilt 1991 · S/N EA-518 N8134QPaul Morrill Excavating Inc · Newcastle, CABuilt 1969 · S/N 414-0034 N8138GRab Com Limited · Hayward, CABuilt 1971 · S/N 21059438 N8139LWashburn Kyle A · Yukon, OKBuilt 1974 · S/N 21060626 N813DMAp-1 LLC · Newman Lake, WABuilt 1975 · S/N 21060946 N813JSDiamondhead Aviation LLC · Omaha, NES/N 32R-8229034 N8145QWestern Nebraska Community College · Scottsbluff, NES/N 414-0045 N814SWWenman Bradford Harris · Johnson, KSS/N 340-0197 N8150QSouthern Journey LLC · South Padre Island, TXS/N 414-0050 N8151QMiller James A Md · Merino, COS/N 414-0051

Back to AD 89-24-01 R1