Skip to content

Registered aircraft · 40,394

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:79-10-03-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:79-10-03-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:79-10-03-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:79-10-03-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:79-10-03-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:79-10-03-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.

N9515KBoyd Matthew · Hudsonville, MIBuilt 1976 · S/N 28-7615209 N95160Registration Pending · Lakewood Ranch, FLRegistration pendingBuilt 1969 · S/N 28-25829 N9516KSmith Dalton L Trustee · Smyrna, DEBuilt 1976 · S/N 28-7615210 N95173First Flight Corporation · San Diego, CABuilt 1969 · S/N 28-25832 N9517DLarson David R · Boerne, TXBuilt 1958 · S/N 22-6433 N9517JBanks Brian H · Zebulon, GABuilt 1966 · S/N 28-3640 N95181Stahl Jason R · Etters, PABuilt 1969 · S/N 28-25835 N9518SSprunk Logan J · Chaffee, NDBuilt 1965 · S/N 7GCB-283 N9518WMarshall Christopher · Oshkosh, WIBuilt 1967 · S/N 28-22944 N95192Kilo Fox Aviation LLC · Saint Joseph, MIBuilt 1969 · S/N 28-25837 N95198Hippen Justin L · Virginia, NEBuilt 1969 · S/N 28-25839 N9519DCraig Reginald S · Deville, LABuilt 1958 · S/N 22-6435 N9519JBarlia David L · Anaheim, CABuilt 1966 · S/N 28-3643 N951ACCotyk Andrew L · Galesburg, MIBuilt 2024 · S/N 90072 N951ANNorth Branch Aviation LLC · Fort Worth, TXBuilt 1974 · S/N AA5-0669 N951HCUsweixin · Sheridan, WYBuilt 1980 · S/N 172RG0282 N951KCN951kc LLC · Rehoboth Beach, DEBuilt 1995 · S/N 2526 N951MKFeliciano Gordon F Jr · Thornton, COBuilt 1977 · S/N AA5B0613 N951RVSeverance Ryan N · Darwin, MNBuilt 2009 · S/N 90337 N951SMBurks Aviation Inc · Hattiesburg, MSBuilt 2004 · S/N 21084C N95203Neptune Aviation Services Inc DBA · Missoula, MTBuilt 1969 · S/N 28-25840 N9520JStaples Laurence C · Makanda, ILBuilt 1966 · S/N 28-3645 N9520SPease Richard C · Snow Camp, NCBuilt 1965 · S/N 8 N95211Massey Aviation LLC · Ashburn, GABuilt 1969 · S/N 28-25843 N95217Laight Kevin · Greeneville, TNS/N 28-25844 N9521HJordan Recreation Development LLC · Clinton, TNBuilt 1975 · S/N 17266197 N9521JGeesaman Brian K · Mount Pleasant, PABuilt 1966 · S/N 28-3739 N9521WFlap Happy LLC · Sheridan, WYBuilt 1967 · S/N 28-22948 N95225Cherokee 95225 LLC · Provo, UTS/N 28-25851 N9522HUrbas Robert M · Rockford, ILBuilt 1975 · S/N 17266198 N9522WPrio Frank A · Milwaukee, WIBuilt 1967 · S/N 28-22949 N95231Duncan Paul D · Norfolk, NEBuilt 1969 · S/N 28-25856 N95236Plane Crazy LLC · Bennington, NEBuilt 1969 · S/N 28-25857 N95237Klassen Glenn Kurt · Chandler, AZBuilt 1969 · S/N 28-25858 N95238Date Greg · Spokane Valley, WABuilt 1969 · S/N 28-25859 N9523DHauser Nathan S · Newark, DEBuilt 1958 · S/N 22-6431 N9523HVictor James A · Kingsville, OHBuilt 1975 · S/N 17266199 N9523JMichalka James R · Portage, MIBuilt 1966 · S/N 28-3648 N9523LCnaa LLC · Mooresville, NCBuilt 1974 · S/N AA5-0523 N9523WOberg Harry W C III · Evanston, WYBuilt 1967 · S/N 28-22950 N95244Banas Darryl P · Waco, TXBuilt 1969 · S/N 28-25861 N9524JZanella Paul J · Ballston Spa, NYBuilt 1966 · S/N 28-3649 N9524LHritz Michael G · Carlisle, PABuilt 1974 · S/N AA5-0524 N95253Mmou LLC · Fort Worth, TXBuilt 1969 · S/N 28-25862 N95255Herren Robert H · Lexington, KYBuilt 1969 · S/N 28-25863 N95259Erickson Landon S · Fairbanks, AKBuilt 1969 · S/N 28-25866 N9525JSandpiper Nag LLC · Louisville, KYBuilt 1966 · S/N 28-3650 N95264Jorquez Andrew D · Santa Paula, CABuilt 1969 · S/N 28-25867 N95265Red River Aviation Services LLC · Altus, OKS/N 28-25868 N95266Walton Robert · Franklin Lakes, NJS/N 28-25869

Back to AD 79-10-03 R2