Registered aircraft · 657

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:91-25-08-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:91-25-08-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:91-25-08-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:91-25-08-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:91-25-08-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:91-25-08-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.

N18TCAviotti Inc · Henderson, NVBuilt 1978 · S/N 421C0503 N196FSTechnical Education Services Inc · Virginia Beach, VABuilt 1978 · S/N 421C0501 N1QMAhlhorn Travis W · New Braunfels, TXBuilt 1979 · S/N 421C0701 N200BNRubber Duck Aviation LLC · Brunswick, GABuilt 1980 · S/N 421C0881 N200DCBjg Aviation I LLC · Neelyville, MOBuilt 1981 · S/N 421C1223 N200EKBw Air LLC · Pierre, SDBuilt 1984 · S/N 425-0205 N200TNI & V Aviation LLC · Missoula, MTBuilt 1978 · S/N 421C0444 N202AASimply Living LLC · Fort Myers, FLBuilt 1980 · S/N 421C1015 N202DBClipper Air LLC · Cresson, TXBuilt 1978 · S/N 421C0488 N207RS5m Consulting LLC · Uvalde, TXBuilt 1984 · S/N 4250195 N212RVMinuteman 12 LLC · Wilmington, DES/N 421C0684 N214CCSteele Aviation LLC · Tuscaloosa, ALS/N 421C0670 N215MPPersson Timothy J · Kansas City, KSS/N 421C1231 N21SGTwo One Sierra Golf LLC · Seattle, WABuilt 1976 · S/N 421C0039 N21SSMidwest Corporate Air Inc · Bellefontaine, OHBuilt 1978 · S/N 421C0473 N21WUDallas Aero & Sales LLC · Poplar, MTBuilt 1979 · S/N 421C0650 N228JHBuzzed Landing LLC · Ocean Springs, MSBuilt 1980 · S/N 421C-1006 N230MWGot Wings LLC · Woodbury, NYS/N 421C0671 N2349SAjs Aviation LLC · Warroad, MNS/N 421C1209 N237SMWestern Rivers Aircraft LLC · Paducah, KYBuilt 1976 · S/N 421C0237 N239JPTj Air Holdings Inc Trustee · Wilmington, DES/N 425-0016 N23RLCaljet Inc · Van Nuys, CABuilt 1981 · S/N 421C1094 N241EWFort Carlos LLC · Fort Worth, TXBuilt 1978 · S/N 421C-0496 N241MWAircraft Guaranty Corp Trustee · Oklahoma City, OKBuilt 1975 · S/N 421C0030 N245CRBlue Eagle Aviation LLC · Danville, CAS/N 4250063 N245THigh Country Aero Ltd · Berthoud, COS/N 421C1104 N24GBSmith Loren · Great Falls, MTS/N 421C0287 N24TWCopper Rose LLC · Beaverton, ORBuilt 1981 · S/N 425-0132 N251JLGolden Eagle 421 LLC · Alsip, ILBuilt 1977 · S/N 421C0311 N260RAUpward Aviation LLC · Tulsa, OKBuilt 1980 · S/N 421C1004 N262MCAerospace Trust Management LLC Trustee · Wilmington, DES/N 421C0140 N264DCAirdvm LLC · Rcho Sta Marg, CABuilt 1982 · S/N 421C1248 N26533Txoperation LLC · Fort Scott, KSBuilt 1979 · S/N 421C0686 N26560Rockslide Analytics Inc · Livermore, CAS/N 421C0802 N2657GB & K Leasing Inc · Nantucket, MAS/N 421C0809 N2657NLoreto Aviation LLC · Wahoo, NES/N 421C0811 N26588Golden Aero LLC · Tarpon Springs, FLBuilt 1980 · S/N 421C0835 N2658ZVirtue Genetics LLC · Cedar Rapids, IAS/N 421C0827 N265RGHerron Aviation Group LLC · Dexter, MIS/N 421C0833 N2660UUnited Front Holdings LLC · Laguna Hills, CABuilt 1981 · S/N 421C1210 N2668ASouthern Aircraft Consultancy Inc Trustee · Casper, WYBuilt 1981 · S/N 421C1216 N268JBIn Tune Entertainment Inc · Scottsdale, AZBuilt 1980 · S/N 421C0866 N269CGold Beach Lumber Yard Inc · Brookings, ORS/N 421C0170 N26GDGragert Richard Trustee · Katy, TXBuilt 1978 · S/N 421C0448 N26HEMccreery Aviation Co Inc · Mcallen, TXBuilt 1979 · S/N 421C0687 N26LFForte Paul · West Bloomfield, MIS/N 421C0710 N274MBAdams Aviation Services Inc Trustee · Wilmington, DEBuilt 1977 · S/N 421C0315 N284DMDreamworks Aviation LLC · Palm Beach Gardens, FLBuilt 1984 · S/N 421C1406 N28RHNational Airplane Sales & Leasing Corp · Lima, OHBuilt 1980 · S/N 421C0847 N28WDOptio Air LLC · Moore, OKS/N 421C0715

Back to AD 91-25-08 R1