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.

N9351NHess Garrett J · Fullerton, CABuilt 1969 · S/N 28R-35054 N9370NWings Over Texas Holdings LLC · Denton, TXBuilt 1969 · S/N 28R-35078 N93722Ridgely Austin · Parkersburg, ILBuilt 1980 · S/N 25-0477 N9373NNelson Charles D · Wibaux, MTS/N 28R-35081 N9380CKillion Jerry · Lubbock, TXBuilt 1978 · S/N 28R-7803256 N9384RBas Part Sales LLC · Greeley, COBuilt 1980 · S/N 25-0478 N93CCRps Aviation Group LLC · Slinger, WIBuilt 1977 · S/N 28R-7803157 N93JNPj Aviation Holding LLC Trustee · Eden Prairie, MNBuilt 1980 · S/N 34-8070175 N93WABranciforte Louis N · Watsonville, CABuilt 1977 · S/N 34-7770390 N9415UVostretsov Evgeny · Cambridge, MABuilt 1980 · S/N 25-0480 N942CDRustad Zachary · Lincoln, NEBuilt 2002 · S/N 1195 N94312Seeba Thomas D · Reno, NVBuilt 1980 · S/N 25-0482 N943RGSegal Briar N Trustee · Tucson, AZBuilt 1979 · S/N 28-7921049 N944RVJohnson Craig A · Newnan, GABuilt 2016 · S/N 91564 N9450CStadler Kristopher D · Makawao, HIS/N 34-7870188 N945ASA2g International LLC · San Juan Capo, CABuilt 1978 · S/N 33701844 N946PKPrado Mike · Sugar Land, TXBuilt 1980 · S/N R1723339 N9472CRhoads Timothy C · Logan, NMBuilt 1978 · S/N 28R-7803260 N9480KLegacy Pursuit LLC · Godfrey, ILBuilt 1976 · S/N 34-7670206 N948FBDye James R · Munster, INBuilt 1998 · S/N 3449057 N94JBIntegrity Aero LLC · Boerne, TXBuilt 1979 · S/N 25-0265 N950MGDurante Salvatore · Oro Valley, AZBuilt 1977 · S/N R1722623 N951DTMontana Aircraft Trust Inc Trustee · Bozeman, MTBuilt 2005 · S/N 1560 N951GPBlind Dog Aviation LLC · Jacksonville, FLS/N 34-8070052 N951LPGiere Steven M · Battle Ground, WABuilt 2008 · S/N 72470 N9528CAldrich Air Transport LLC · Saint Augustine, FLBuilt 1978 · S/N 34-7870195 N952ASA2g International LLC · San Juan Capo, CABuilt 1978 · S/N 33701835 N952DSAnderson James B IV Trustee · Glendale, AZBuilt 2000 · S/N 1102 N953ASA2g International LLC · San Juan Capo, CABuilt 1978 · S/N 33701872 N9540VCapital Aviation LLC · Bismarck, NDBuilt 1980 · S/N 25-0487 N9542ZD Danger LLC · Allentown, PABuilt 1980 · S/N 25-0488 N95442Pressley Brent DBA · Morristown, TNBuilt 1980 · S/N 25-0489 N9547UWheels & Wings Inc · Staten Island, NYBuilt 1980 · S/N 25-0490 N954ASA2g International LLC · San Juan Capo, CABuilt 1980 · S/N 33701940 N954ERWalker Paul Charles · Burleson, TXBuilt 1963 · S/N 336-0041 N9554UMidway Enterprises Inc · Wilmington, DEBuilt 1980 · S/N 25-0492 N9565VHijazi Sakher Samir · San Clemente, CABuilt 1977 · S/N R1722332 N95662Schopp Ty P · Hernando, MSS/N 25-0493 N9569KSafeco Leasing LLC · Port Alsworth, AKBuilt 1947 · S/N 108-2569 N956ASA2g International LLC · San Juan Capo, CABuilt 1978 · S/N 33701848 N9573CBarber Scott H · Redwood Falls, MNBuilt 1978 · S/N 34-7870198 N9582UJohnson Daniel L · Menomonie, WIBuilt 1980 · S/N 25-0496 N9590UN9590u LLC · Miami, FLS/N 25-0498 N9595VSmith Ryan N · Saratoga Springs, UTBuilt 1977 · S/N R1722335 N959WATailwind Flyers LLC · Guilderland, NYBuilt 1982 · S/N 34-8233080 N95DSale Reported · GuernseySale reportedBuilt 1998 · S/N 3449060 N9603CJtp Aviation LLC · Little Canada, MNBuilt 1978 · S/N 34-7870201 N96061Wold Wayne T · Wasilla, AKFirst renewal noticeS/N R1720089 N9613CSmall James F Jr · Great Mills, MDBuilt 1978 · S/N 28R-7803269 N961UTRepllp LLC · Marietta, GABuilt 1977 · S/N R1722337

Back to AD 81-13-10 R1