Registered aircraft · 4,787

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:75-09-13') OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:75-09-13') 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:75-09-13')
    OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:75-09-13')
  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:75-09-13')
  OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:75-09-13')
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.

N1944GBas Part Sales LLC · Greeley, COBuilt 1974 · S/N 421B0844 N1946GPartwin421 LLC · Greenwich, CTBuilt 1974 · S/N 421B0846 N1953UAnstrand Charles Jason · Boise, IDBuilt 1974 · S/N U20602306 N1961UMccarthy Trevor William · Addison, TXBuilt 1974 · S/N U20602312 N196CAHyannis Air Service Inc DBA · Hyannis, MABuilt 1979 · S/N 402C0116 N1973USilver Fox Aviation LLC · Bay City, MIBuilt 1974 · S/N U20602316 N1978FLofty Pursuits LLC · Sacramento, CABuilt 1981 · S/N P21000711 N1987GPhillips Michael M · Angleton, TXBuilt 1974 · S/N 414-0544 N198ERCloud Dancer LLC · Santa Maria, CABuilt 1977 · S/N 21062298 N1995GHarris Justin R · Hico, TXFirst renewal noticeBuilt 1974 · S/N 414-0602 N199PBSkyflite LLC · Hillsboro, ORS/N TJ-137 N199RPId Corporation · Shepherd, MTS/N EA-344 N199TKDangel LLC · Hailey, IDBuilt 1979 · S/N P21000313 N19FBWojnicki Chester · Mt Prospect, ILBuilt 1976 · S/N 21061668 N19LBSanders Brian L · Tehachapi, CABuilt 1982 · S/N 21064705 N19RAAviatzone LLC · Fort Lauderdale, FLS/N TK-44 N1FHBuermann Henry · Brookfield, VTS/N 18052817 N1GQAero Attack Systems (USA) Inc · Blaine, WANon-citizen corporation, flight hours not reportedBuilt 1972 · S/N 421B0236 N1KPSherman Loren R Jr · Granbury, TXBuilt 1973 · S/N 21060006 N1LQStrydom Cornelis F · Liberal, KSBuilt 1966 · S/N T210-0148 N1QGLos Arboles Management Company LLC · Moriarty, NMBuilt 1966 · S/N D-8328 N1QMAhlhorn Travis W · New Braunfels, TXBuilt 1979 · S/N 421C0701 N1YASouthern Aircraft Consultancy Inc Trustee · Casper, WYBuilt 1974 · S/N 421B0580 N2002PGregory Edward · Council Bluffs, IABuilt 1979 · S/N 335-0022 N200BNRubber Duck Aviation LLC · Brunswick, GABuilt 1980 · S/N 421C0881 N200DCBjg Aviation I LLC · Neelyville, MOBuilt 1981 · S/N 421C1223 N200GCDancy Abram P · Shrewsbury, MABuilt 1978 · S/N 340A0503 N200MCN200mc Inc Trustee · Cheyenne, WYBuilt 1973 · S/N 414-0424 N200RCRc Aviation LLC · Omaha, NEBuilt 1975 · S/N 21061073 N200RTRiley Nolan C · Lubbock, TXS/N TK-101 N200UAUrrea Hugo Edmundo Rincon · Houston, TXBuilt 1980 · S/N 21063921 N200WRVaughan Jason B · Sublette, KSBuilt 1978 · S/N 21062478 N2011SHeath Stephen · Alpine, TNBuilt 1975 · S/N 21060979 N2012S9791m LLC · Tacoma, WAS/N 21060980 N2018LKrielow Law Firm LLC · Thibodaux, LABuilt 1978 · S/N TK-80 N2019SMoore Bobby E · Perry, OKBuilt 1975 · S/N 21060987 N201DRegistered aircraftS/N TK-24 N2028SScherler Burl M · Sheridan Lake, COBuilt 1975 · S/N 21060996 N202AASimply Living LLC · Fort Myers, FLBuilt 1980 · S/N 421C1015 N202SWMar Jar LLC · Gilmer, TXFirst renewal noticeBuilt 1980 · S/N 414A0515 N202ZLojas Phillip · San Ysidro, CAS/N 411-0292 N2031ZJames Jeb S Dr · Bay City, TXBuilt 1978 · S/N TJ-165 N2034JMd Aero LLC · Somerton, AZBuilt 1978 · S/N T18803339T N2037ACrosswind Enterprises LLC · Box Elder, SDBuilt 1979 · S/N EA-3 N2037SRubyco Inc Trustee · Wilmington, DEBuilt 1975 · S/N 21061005 N2038SHatch Family Limited Partnership · Winslow, AZBuilt 1975 · S/N 21061006 N203JLJfra LLC · Miami, FLBuilt 1981 · S/N 414A0670 N2043SAppel Daniel E · Redfield, SDBuilt 1975 · S/N 21061010 N2046SYankee Clipper LLC · Dayton, OHFirst renewal noticeS/N 21061013 N2050SDavis Bryan C · Winfield, KSBuilt 1975 · S/N 21061017

Back to AD 75-09-13