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.

N736UBMccall Freddie · Brewton, ALBuilt 1977 · S/N R1722789 N736UETraining Planes Of Texas Inc · Flint, TXBuilt 1977 · S/N R1722792 N736UFLee County Flying Club LLC · Marianna, ARBuilt 1977 · S/N R1722793 N736UGAerospatiale LLC · Yakima, WAS/N R1722794 N736UJN736uj LLC · Tulsa, OKBuilt 1977 · S/N R1722796 N736UKMustard Robert M · Duxbury, MAS/N R1722797 N736UPDavis John F · Westminster, MDS/N R1722801 N736UTIsbell Brian K · Rosenberg, TXBuilt 1977 · S/N R1722804 N736UUCoffyn Clifford J · Boynton Beach, FLBuilt 1977 · S/N R1722805 N736VAFelmlee Don E · Center, COS/N R1722811 N736VBBuell Jack A · St Maries, IDBuilt 1977 · S/N R1722812 N736VDJ-Mac Aviation LLC · Hugoton, KSBuilt 1977 · S/N R1722814 N736VELesure William A · Wadsworth, OHS/N R1722815 N736VGDelaware Aircraft Trust LLC Trustee · New Castle, DEBuilt 1977 · S/N R1722817 N736VJFly White Cloud LLC · Lake Havasu City, AZBuilt 1977 · S/N R1722819 N736VLKaehlert Lottie DBA · Rifle, COS/N R1722821 N736VPKitty Hawk Flight Training And Tours LLC · Kill Devil Hills, NCBuilt 1977 · S/N R1722824 N736VRStalling Dustin R · Florence, AZS/N R1722826 N736VXRocky Mountain Flight Consultants LLC · Boulder, COBuilt 1978 · S/N R1722832 N736VZSuarez Santiago A · Laredo, TXS/N R1722834 N736WCNash Jason · Barrington, NHBuilt 1977 · S/N R1722837 N736WEContinental Capital Corp · Wilmington, DEBuilt 1977 · S/N R1722839 N736WJRatjen Aviation LLC · Naples, FLBuilt 1977 · S/N R1722843 N736WKRegistration Pending · Jenks, OKRegistration pendingBuilt 1978 · S/N R1722844 N736WLInman James F · East Bend, NCBuilt 1977 · S/N R1722845 N736WSMst Ltd · Charlotte, NCBuilt 1977 · S/N R1722851 N736XAReese Brent R · Anchorage, AKBuilt 1978 · S/N R1722859 N736XBAerospace Trust Management LLC Trustee · Wilmington, DEBuilt 1978 · S/N R1722860 N736XCEagle Squadron Inc · The Villages, FLBuilt 1978 · S/N R1722861 N736XDRiverview Flyers LLC · Marysville, PABuilt 1978 · S/N R1722862 N736XERegistered aircraftBuilt 1978 · S/N R1722863 N736XHJlm Ranch Inc · Mullen, NEBuilt 1978 · S/N R1722866 N736XMNorthwest Passage LLC · Anchorage, AKBuilt 1978 · S/N R1722870 N736XNColorado Northwestern Community College · Rangely, COBuilt 1978 · S/N R1722871 N736XSRegistration Pending · Urbandale, IARegistration pendingBuilt 1978 · S/N R1722875 N736XVFreedom Aviation LLC · Riverton, UTBuilt 1978 · S/N R1722878 N736XXMonteiro Aviation LLC · Minneapolis, MNBuilt 1978 · S/N R1722880 N736XZPiotrowski Anthony J · Nanticoke, PABuilt 1978 · S/N R1722882 N736YBCarlson James D · North Andover, MABuilt 1978 · S/N R1722884 N736YDTrans World Aircraft LLC · Quakertown, PABuilt 1978 · S/N R1722886 N736ZBMunning Gregory T Jr · Greensboro, NCBuilt 1978 · S/N R1722908 N736ZWBrethren Pa LLC · Pittsburgh, PABuilt 1978 · S/N R1722927 N7379KSmith Zachary M · Woodworth, LABuilt 1976 · S/N R1722066 N7380KKxp Ventures LLC · Piedmont, SCFirst renewal noticeBuilt 1976 · S/N R1722067 N7381VEvarts Roy K · Northborough, MABuilt 1977 · S/N R1722306 N7385KHaraseviat Mark · Cranberry Township, PABuilt 1976 · S/N R1722069 N739ALFly Rite Aviation LLC · Fort Myers, FLBuilt 1977 · S/N R1722518 N73MJArk Flight LLC · Miramar Beach, FLBuilt 1975 · S/N 34-7670114 N740MHumphrey William A · Grosse Ile, MIBuilt 1965 · S/N 337-0160 N740SBirch Tree Aviation LLC · Unadilla, GABuilt 1969 · S/N 33701221

Back to AD 81-13-10 R1