Registered aircraft · 562

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:2002-10-13') OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:2002-10-13') 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:2002-10-13')
    OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:2002-10-13')
  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:2002-10-13')
  OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:2002-10-13')
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.

N81TBMalachi Leasing Co · Wilmington, DEBuilt 1978 · S/N TJ-147 N822KCLucky Fighter Aviation Services LLC · Lakeland, TNBuilt 1979 · S/N P-499 N82ECInternational Air Services Inc Trustee · Carson City, NVBuilt 1976 · S/N P-376 N831GETs&L Aircraft LLC · Alexandria, MNS/N TJ-293 N831JBDjd Properties LLC · Victoria, TXBuilt 1980 · S/N TJ-279 N833TXN833tx LLC · Little Rock, ARBuilt 1978 · S/N TJ-153 N837RJBrs Inc · Hobson, MTBuilt 1975 · S/N P355 N84PECarosso Kevin V · Santa Cruz, CABuilt 1984 · S/N TJ-470 N850CMN850cm LLC · San Luis Obispo, CABuilt 1972 · S/N P-213 N850DCGolden Compass Aviation LLC · Wilmington, DES/N P-253 N850YRNhv LLC · Orlando, FLBuilt 1981 · S/N P581 N8585RLaminar Capital Ventures LLC · Sheridan, WYBuilt 1974 · S/N P-282 N858KFox Powder LLC · Wilmington, DEBuilt 1981 · S/N P-574 N858MLLang Inc · Wilmington, DEBuilt 1980 · S/N TJ-257 N858PTj-128 LLC · Dover, DES/N TJ-128 N85MEGlobal Petroleum Services LLC · Greenville, SCBuilt 1978 · S/N TJ-168 N8777RFluid Aviation LLC · Saint Clair, MIFirst renewal noticeBuilt 1974 · S/N P-291 N87RRBahnair LLC · Oklahoma City, OKS/N TJ-34 N8831Flyingdriller LLC · Kalispell, MTBuilt 1976 · S/N P-404 N888JTNyerges James · Midland, TXFirst renewal noticeBuilt 1966 · S/N LP-21 N889JBJjj Aviation LLC · Newport, NCBuilt 1974 · S/N P-270 N889TSQualitair LLC Trustee · MichelstadtBuilt 1980 · S/N TJ281 N892MCMcn Aviation LLC · San Antonio, TXBuilt 1975 · S/N P-353 N8BYTarrant County College District · Fort Worth, TXBuilt 1977 · S/N P-452 N8PEEdwards Pacific Aviation Corp · Dover, DEBuilt 1980 · S/N P-540 N8TMAdvanced Intelligent Computing Inc DBA · Houston, TXBuilt 1980 · S/N TJ-325 N901ATQualitair LLC Trustee · MichelstadtBuilt 1974 · S/N P272 N9083SRobinson Charley C · Guthrie, OKBuilt 1978 · S/N TJ-152 N9104YQ&A Holdings LLC · Elkridge, MDBuilt 1976 · S/N P-382 N911MAJohnson Jeffery V · Floydada, TXBuilt 1973 · S/N P-225 N911SLund Mark · Wasilla, AKBuilt 1974 · S/N P-317 N916JWSouth Delta Aviation Inc · Fayetteville, ARBuilt 1976 · S/N TJ-91 N920CBOgden Newspapers Inc · Wheeling, WVBuilt 1981 · S/N TJ-380 N921AWJjmb Customs LLC · Port Saint Lucie, FLS/N P-292 N925TPKtm Projects LLC · Durant, OKBuilt 1976 · S/N TJ-35 N925VVEndicott Properties LLC · Hilton Head Island, SCS/N TJ188 N928RSEzskies Air Service LLC · Hayden, IDBuilt 1978 · S/N TJ-138 N945GWAlcyone Trust Corp Trustee · Wichita, KSBuilt 1979 · S/N P-497 N946HRPalm Beach Motorsports Transportation Division LLC · Helena, MTS/N P-551 N947GBGreat Lakes Aircraft Inc · Fort Myers, FLBuilt 1975 · S/N P-365 N94PBBaron 94pb LLC · Tuscaloosa, ALBuilt 1979 · S/N TJ-245 N953DSShows Douglas · Seabrook, TXBuilt 1983 · S/N TJ-443 N958PDrew Jensen Inc · Lincoln, NEBuilt 1978 · S/N TJ-139 N958PBMo Elite Air LLC · Rolla, MOBuilt 1981 · S/N TJ-392 N95BHSale Reported · Lacombe, LASale reported, canceledBuilt 1975 · S/N TJ-29 N963SGElephant Shoe Air LLC · Vienna, VABuilt 1984 · S/N TJ-452 N966UBTex Ark Air Corp · Melissa, TXBuilt 1977 · S/N TJ-120 N96PTEidson Mark C · Weatherford, TXBuilt 1976 · S/N TJ-31 N97VCSababa Aviation LLC · West Palm Beach, FLBuilt 1985 · S/N TJ-495 N98BBSouthern Aircraft Consultancy Inc Trustee · Casper, WYBuilt 1979 · S/N TJ-193

Back to AD 2002-10-13