Registered aircraft · 489

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

N100BABemidji Aviation Services Inc · Bemidji, MNBuilt 1968 · S/N U12 N100PYTbm Flying Lc · Pampa, TXBuilt 1981 · S/N BB-890 N101MCMarc Inc · Bolton, MSBuilt 1973 · S/N T234 N106RHSouthern Bracing Systems Inc · Armuchee, GABuilt 1978 · S/N BB-428 N108ALRj Flight LLC · Saint Petersburg, FLBuilt 1980 · S/N BB-730 N108BABemidji Aviation Services Inc · Bemidji, MNS/N U-40 N109CZN109cz LLC · Milwaukee, WIBuilt 1969 · S/N U-109 N110GGo Soar LLC · Highland Village, TXBuilt 1980 · S/N BB-792 N111PVHenson Builders LLC · Dallas, TXBuilt 1981 · S/N BB-772 N113MHCasavia Corp · Guelph OntarioBuilt 1980 · S/N T330 N113WATvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTBuilt 1979 · S/N 110 205 N115WATvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTBuilt 1964 · S/N 110451 N116WATvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTBuilt 1982 · S/N 110.399 N117CCEv Advisors LLC · Scottsdale, AZBuilt 1979 · S/N T-325 N117WATvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTBuilt 1982 · S/N 110.388 N118MDAlpine Aviation Inc · Provo, UTBuilt 1969 · S/N U-118 N118WATvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTBuilt 1980 · S/N 110.250 N120RLIsr Platforms LLC · Mclean, VABuilt 1979 · S/N BT-9 N120TMInterstate Automotive Services Inc · Franklin, TNBuilt 1981 · S/N T-405 N120WATvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTBuilt 1982 · S/N 110.404 N121LBEastern Stearman Inc Trustee · Leesburg, VAS/N BB-475 N124KTGams Air LLC · Doral, FLBuilt 1976 · S/N BB-124 N124WRH.A.I. Services Inc · Justin, TXBuilt 1980 · S/N BB-664 N125BKColoramo Federal Credit Union · Grand Junction, COBuilt 1982 · S/N BB-977 N126JHM&P Aviation LLC · Lakeland, TNBuilt 1980 · S/N BB-595 N127GABeech Transportation Inc · Eden Prairie, MNBuilt 1977 · S/N BB312 N127TACompany Wrench Ltd · Carroll, OHBuilt 1980 · S/N BB-636 N128SFWin Win Aviation Inc · Wake Forest, NCBuilt 1969 · S/N U-87 N12MFMontana Aircraft Trust Inc Trustee · Bozeman, MTS/N T-417 N12NGNorthrop Grumman Systems Corp · El Segundo, CABuilt 1979 · S/N BB-581 N12YZTanglefoot Wing & Wheel Co · Coolin, IDBuilt 1946 · S/N J2 N130BABemidji Aviation Services Inc · Bemidji, MNBuilt 1969 · S/N U-80 N130FBMayes John · Carson City, NVBuilt 1947 · S/N J-30 N130RLOscar Charlie II LLC · California, MDBuilt 1980 · S/N BT16 N131SJGravitas Aviation LLC · Dallas, TXBuilt 1976 · S/N BB-131 N137BABemidji Aviation Services Inc · Bemidji, MNBuilt 1970 · S/N U137 N139RRRyan Renae L Trustee · Wichita, KSBuilt 1976 · S/N BB-177 N140RLN140rl LLC · Kalispell, MTBuilt 1982 · S/N BT22 N143DEAac 585 LLC · Kennesaw, GABuilt 1979 · S/N BB-585 N145WFAircraft Propulsion Leasing LLC · Holland, OHBuilt 1993 · S/N DC-824B N14MVAlpine Aviation Inc · Provo, UTBuilt 1969 · S/N U59 N151ELCarolina Turbine Sales Inc · Raleigh, NCBuilt 1978 · S/N BB-371 N152AFUas Transervices Inc · Boca Raton, FLBuilt 1982 · S/N AC520 N152WLHeart One LLC · Little Rock, ARBuilt 1977 · S/N BB-260 N158MCBemidji Aviation Services Inc · Bemidji, MNBuilt 1988 · S/N AC-726B N158WAHkb Aviation LLC · San Antonio, TXBuilt 1981 · S/N TC411 N159MCGas/Wilson Inc · Traverse City, MIS/N AC-728B N15KALighthouse Air LLC · Hobe Sound, FLBuilt 1979 · S/N BB-457 N160SFTriumph Aviation LLC · Gaylord, MIBuilt 1975 · S/N BB-32 N164HAUas Transervices Inc · Boca Raton, FLBuilt 1968 · S/N U-60

Back to AD 97-01-12