Registered aircraft · 10,639

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:99-01-05-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:99-01-05-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:99-01-05-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:99-01-05-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:99-01-05-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:99-01-05-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.

N9766DMayer Gregory B · Fall River Mills, CABuilt 1959 · S/N 22-6682 N9767PVanhorne Robert E · Centralia, ILBuilt 1974 · S/N 25-7556039 N9770DDestaffany Nelson D · Crawford, TXBuilt 1959 · S/N 18-6828 N9771DHull Christian M · Palmer, AKBuilt 1959 · S/N 18-6830 N9774DRegistration Pending · Wolf Point, MTRegistration pendingBuilt 1959 · S/N 18-6835 N9776D76 Delta LLC · Garwood, TXBuilt 1959 · S/N 18-6837 N9777DRouse Kenneth L Jr · Joseph, ORBuilt 1957 · S/N 18-6191 N9777PAerial Banners Inc · Pembroke Pines, FLS/N 25-7556089 N9779DTri-W Inc · Shepherd, MTS/N 18-6848 N977VMVan Hatten Michael Sr · Fairbanks, AKBuilt 1953 · S/N 18-2839 N9780DTubreaux Aviation Services LLC · Shreveport, LABuilt 1959 · S/N 18-6849 N9780PBell Robert A Jr · Scotland Neck, NCBuilt 1974 · S/N 25-7556068 N9783DBulawa Austin R · Wasilla, AKBuilt 1959 · S/N 18-6853 N9784DOrth Henry J · Wasilla, AKBuilt 1959 · S/N 18-6854 N9785PBurbank Franklin R · Ocala, FLS/N 25-7556096 N9786PSean Smith · Palmer, AKBuilt 1976 · S/N 18-7609029 N9788DGlynn Blake Trustee · Cedar Hill, TNBuilt 1959 · S/N 18-6860 N9789DStewart Jonah M · Wasilla, AKBuilt 1959 · S/N 18-6861 N9792DMoalli John · Friday Harbor, WABuilt 1959 · S/N 18-6867 N9795DKennedy Gary R · Sanger, TXBuilt 1959 · S/N 18-6870 N9796DSki Ag Aviation LLC · Bismarck, NDBuilt 1959 · S/N 18-6872 N9798PCorbett Harry F · San Luis Obispo, CABuilt 1976 · S/N 18-7609031 N97SARegistration Pending · Peosta, IARegistration pendingBuilt 1975 · S/N 18-7509117 N9800DHallada David A · Stanton, MIBuilt 1947 · S/N 11-261 N9800PGrisham Steve DBA · Belzoni, MSBuilt 1976 · S/N 18-7609032 N9803DAttitude Aerobatics LLC · Wilmington, DEBuilt 1959 · S/N 22-6690 N9803PLosse Randall J · Wasola, MOBuilt 1975 · S/N 25-7556118 N9804DEngbring Tim · Valmeyer, ILBuilt 1959 · S/N 22-6691 N9806PSouthern Aircraft Consultancy Inc Trustee · Casper, WYBuilt 1975 · S/N 25-7556122 N9808DPresho Glen · Hereford, AZBuilt 1959 · S/N 22-6695 N9809PMit Soaring Association Inc · Sterling, MABuilt 1975 · S/N 25-7556123 N9811DWilson Jackson R F · Talkeetna, AKS/N 22-6698 N9814DGupton Scott W · Prescott Valley, AZBuilt 1959 · S/N 22-6701 N9814PBeardsley Taylor J · Miles City, MTFirst renewal noticeBuilt 1976 · S/N 18-7609033 N9815PTucson Soaring Club Inc · Sahuarita, AZBuilt 1975 · S/N 25-7556129 N9816DWierda Evert T · Manhattan, MTBuilt 1959 · S/N 22-6703 N98197Barnes Bryce S · East Jordan, MIBuilt 1946 · S/N 18358 N9819PHolder R William · Pittsfield, PABuilt 1975 · S/N 25-7556136 N9824PKnutson Wayne R · Thompson, NDBuilt 1975 · S/N 25-7556142 N9827DQuality Aviation Inc · Marana, AZS/N 22-6717 N9827PSmith Terry L · Cedar Hill, TNS/N 25-7556146 N98283Mcginley Aviation Inc · Ocala, FLBuilt 1946 · S/N 18457 N9829QChesnut Lonnie R · Palmer, AKBuilt 1954 · S/N 18-3328 N982WKnox Warren Henry · Santa Cruz, CABuilt 1962 · S/N 22-9219 N9830PHolmgren Michael G · Kulm, NDBuilt 1975 · S/N 25-7556148 N9831DHiginbotham Larry L · Littleton, COBuilt 1959 · S/N 22-6722 N9831QMio William A · Intl Falls, MNS/N 18-3352 N9832DNimmick Robert A · Three Forks, MTBuilt 1959 · S/N 22-6723 N9833QRussell Michael A · Randolph, MNBuilt 1953 · S/N 18-3358 N98349Odyssey Aircraft LLC · Topeka, KSBuilt 1946 · S/N 18520

Back to AD 99-01-05 R1