Skip to content

Registered aircraft · 81,733

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-18-04-R2') 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-18-04-R2') 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-18-04-R2')
    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-18-04-R2')
  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-18-04-R2')
  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-18-04-R2')
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.

N46007Aircraft Builders Associates LLC · Tempe, AZBuilt 2008 · S/N 549702 N4600JDavis Robert M · Dallas, NCBuilt 1979 · S/N 17273652 N46011Jackson William T · Clinton, OHBuilt 1968 · S/N 17256986 N46015Leaders Flying Service LLC · Clear Lake, MNS/N 17256988 N46019La Porte Aero Club Inc · La Porte, INS/N 17256992 N4601GResicum International LLC · Gulf Shores, ALBuilt 1979 · S/N 17273270 N4601JHardin John M · Terrell, TXBuilt 1968 · S/N 28R-30479 N4601VDuffys Aircraft Sales & Leasing Inc · Neillsville, WIBuilt 1980 · S/N 172RG0336 N4601XMast Aviation LLC · South Boston, VABuilt 1966 · S/N 15064651 N46020Registration Pending · Brooksville, FLRegistration pendingBuilt 1978 · S/N 15282984 N46021152 4 Fun LLC · Gilbert, SCBuilt 1978 · S/N 15282985 N46024Garfield Joshua E · Tampa, FLBuilt 1968 · S/N 17256995 N46027Cleary Thomas J · Fairport, NYBuilt 1968 · S/N 17256997 N46028First Take Aviation LLC · Van Nuys, CABuilt 1968 · S/N 17256998 N4602JNew Garden Township · Landenberg, PAS/N 28R-30481 N4602SKeniston Kimberly A · Tyngsboro, MABuilt 1979 · S/N R18201353 N4602ZMoorefield Oscar W · Monroe, GABuilt 1961 · S/N 22-8116 N46030Constance Air LLC · Luthersville, GABuilt 1968 · S/N 17257000 N46031Soucy Gary J · Brewer, MEBuilt 1968 · S/N 17257001 N46034Employment Services Inc · Virginia Beach, VABuilt 1978 · S/N 15282986 N4603JAll American Aviation Services Inc · Fayetteville, NCBuilt 1968 · S/N 28R-30482 N4603MAshley Don E · Willow, AKBuilt 2019 · S/N 0865 N4603RRadcliff Rocky J Sr · Tehachapi, CABuilt 1965 · S/N 28-21351 N4603VLazy Ta Legend Aircraft LLC · Wilmington, DEBuilt 1977 · S/N VAC77-77 N4603ZN4603z Colt Flyers LLC · Kenmore, WAS/N 22-8117 N46045Rabb Randolph W · El Cajon, CABuilt 2015 · S/N 75-8409 N46047Loudermilk John A · Nashville, TNBuilt 1968 · S/N 17257010 N4604JTrouth Kevin J · Sulphur, LAS/N 28R-30483 N4604WPlotkin Terry M · Colorado Springs, COS/N 13094 N4604XDelaware Aircraft Trust LLC Trustee · New Castle, DEBuilt 2012 · S/N 91252 N46050Sentinel Services Group LLC · Brooksville, FLS/N 28-7325267 N46054Cabirdassou Meena · Arcadia, CABuilt 1968 · S/N 17257015 N46057Flight Time Builders Inc · Memphis, TNBuilt 1968 · S/N 17257018 N4605JNichols James M · Duanesburg, NYS/N 28R-30485 N4605RFive Eagles Group LLC · Pompano Beach, FLBuilt 1966 · S/N 28-21353 N4605WCoyner Philip C · Belpre, OHBuilt 1976 · S/N 13095 N46060Registration Pending · Factoryville, PARegistration pendingBuilt 1968 · S/N 17257019 N4606JKantor Robert James · Rancho S Margarita, CABuilt 1968 · S/N 28R-30486 N4606RAiken Pilot Training LLC · Johnston, SCBuilt 1965 · S/N 28-21354 N4606WCornwell Stephen E · Beaumont, TXBuilt 1976 · S/N 13096 N4606YAdirondack Soaring Association Inc · Ballston Spa, NYBuilt 1967 · S/N 25-4303 N46072Fly Anytime LLC · Kankakee, ILBuilt 1968 · S/N 17257025 N46075Perspective Aviation LLC · Comer, GABuilt 1978 · S/N 15282995 N46078Parrish Aviation Flight Academy LLC · Southlake, TXBuilt 1968 · S/N 17257030 N4607JHodgen Robert T III · Lexington, KYBuilt 1968 · S/N 28R-30487 N4607RBayside Aviators LLC · Union City, CAS/N 28-21356 N4607WWalmer David H · Tualatin, ORBuilt 1976 · S/N 13097 N46080Sentinel Services Group LLC · Brooksville, FLBuilt 1978 · S/N 15282227 N46085Davenport Jimmy J · Hayesville, NCBuilt 1974 · S/N 17264175 N46087Range Steven V · Greenfield, ILBuilt 1968 · S/N 17257034

Back to AD 81-18-04 R2