Skip to content

Registered aircraft · 4,001

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:81-13-10-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:81-13-10-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:81-13-10-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:81-13-10-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:81-13-10-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:81-13-10-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.

N47682Byerly James · Virginia Beach, VABuilt 1977 · S/N 28R-7703422 N476JBArchipelago Group LLC · Alexandria, VABuilt 1977 · S/N 28R-7703419 N47707Stateler Mickey S · Fort Worth, TXS/N 28R-7803001 N47726Pier To Plateau Aviation Services LLC · Wilmington, DES/N 28R-7803005 N47728Jr Aircraft Services LLC · Oxford, MIBuilt 1977 · S/N 28R-7803006 N47739Tnl Management LLC · Cullman, ALBuilt 1977 · S/N 28R-7803008 N47740Media Stew LLC · Carson City, NVBuilt 1977 · S/N 28R-7803009 N47742Jmd Enterprises LLC · Thompsons Station, TNBuilt 1977 · S/N 28R-7803011 N47761Engholm Jeffrey H · Bauxite, ARBuilt 1977 · S/N 28R-7803012 N47763Premier Management Co · Mobridge, SDBuilt 1977 · S/N 28R-7803014 N47766N47766 LLC · Pembroke Pines, FLBuilt 1977 · S/N 34-7870002 N47805Premier Aviation LLC · Sioux Falls, SDS/N 28R-7803016 N47810Nrg Systems N W LLC · Gresham, ORBuilt 1977 · S/N 28R-7803019 N47815Fino Plane Co · Farmington, MIBuilt 1977 · S/N 34-7870004 N47826Rogerson Andrew C · Kingsland, TXBuilt 1977 · S/N 28R-7803021 N47827Alford James L · Mckinney, TXBuilt 1977 · S/N 28R-7803022 N4783HAckerman David M · Prospect, KYBuilt 1979 · S/N 25-0225 N47842S&L Farm And Ranch LLC · Roseburg, ORS/N 28R-7803025 N47848Sloan Paris Company LLC · Lake Worth, FLBuilt 1977 · S/N 34-7870008 N47874Matthews John M · Mount Pleasant, TXBuilt 1977 · S/N 28R-7803032 N47877Trying Harder Flight LLC · Cheyenne, WYBuilt 1977 · S/N 34-7870010 N47878Hunt Michael A · Siloam Springs, ARBuilt 1977 · S/N 34-7870011 N47895Seneca Aeronautical Services LLC · Wilmington, DEBuilt 1977 · S/N 34-7870012 N47912Maxey Russell J · Midland, TXFirst renewal noticeS/N 28R-7803037 N47915Lewis Mechanical Inc · Wasilla, AKBuilt 1977 · S/N 34-7870014 N47987Mongo Corp · Santa Fe, NMBuilt 1977 · S/N 28R-7803052 N47990Williams Charles · Wadsworth, OHBuilt 1977 · S/N 34-7870024 N479CCRood Donald F · San Diego, CABuilt 1985 · S/N 25-1007 N47BEWestgard Richard W · Golden, COBuilt 1984 · S/N 25-0800 N47RJBzm LLC · Incline Village, NVS/N 25-0525 N480NDIsland Jet Co · Merritt Island, FLS/N 3449306 N480WLRocky Mountain Flight Consultants LLC · Boulder, COBuilt 1963 · S/N 336-0060 N481CDMeyer Eric · Fort Lauderdale, FLBuilt 2005 · S/N 1488 N48233Miller Robert S · Mesa, AZBuilt 1968 · S/N 337M0294 N48237Yoder Airways LLC · Fayetteville, GABuilt 1967 · S/N R172-0171 N48317Rhoden Gregory L · Sarasota, FLBuilt 1967 · S/N R172-0051 N48322Stroemsvik Kristian · Strasburg, VAS/N R172-0213 N4832VGiovanni Greco · Centennial, COBuilt 1980 · S/N 25-0371 N484HPFly With Kay LLC · Fulshear, TXBuilt 1981 · S/N 34-8133199 N488QBeavertail LLC · Darien, CTBuilt 1984 · S/N 34-8433046 N488RAWest Bottoms Properties Inc · Iola, KSBuilt 1977 · S/N R1722539 N48FMAvworth Aviation Consulting Inc · Florence, KYBuilt 1998 · S/N 24-3428 N48LJSga Alaska Leasing LLC · Anchorage, AKBuilt 1977 · S/N 347770030 N48SLLauff Samuel Jr · Ocala, FLBuilt 1975 · S/N 34-7570042 N48WRRasquinha Warren · Sanford, FLBuilt 1977 · S/N 28R-7703355 N490CDGiron Mercedes · Atlanta, GABuilt 2005 · S/N 1559 N493WCOsness Rhonda R · Bisbee, NDBuilt 1973 · S/N P3370090 N4949FGregory Scott · Quincy, MABuilt 1976 · S/N 28R-7703002 N49885Lilja Daniel R · Plains, MTBuilt 1971 · S/N R1720156 N49920Maw Robert J Jr · Albuquerque, NMBuilt 1973 · S/N P337-0092

Back to AD 81-13-10 R1