Registered aircraft · 40,396

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.

N5291EBreslin Denis M · El Cajon, CABuilt 1978 · S/N 17271820 N5291SWilliams Scott H · Renton, WABuilt 1970 · S/N 28-26913 N52922Northwest Flyers Inc · Marianna, FLBuilt 1981 · S/N 17274635 N5292EJam Three LLC · Saint George, UTBuilt 1978 · S/N 17271821 N5292KBates Field Aero Club Inc · Mobile, ALBuilt 1980 · S/N 17274048 N5292REss Adventures LLC · Damascus, ARBuilt 1974 · S/N 17263506 N5292SVermilyea Paul E · Newton, KSBuilt 1970 · S/N 28-26923 N52939Warwas Steven M · Yorktown, TXBuilt 1981 · S/N 17274641 N5293KBrooks Jimmy · O Fallon, ILS/N 17274049 N5293SBullock Agency Inc · Saint Charles, ILBuilt 1970 · S/N 28-26841 N5294LBreidenbach Amy K · Onalaska, WIBuilt 1968 · S/N 28-4595 N5294RRemus Stephen J · Warren, MIBuilt 1974 · S/N 17263508 N5294XCarrigan Roy K · Oak Grove, MNS/N 2220 N52950Jin Jin Aviation LLC · Anchorage, AKBuilt 1981 · S/N 17274642 N52953Pacific Fleet Aviation LLC · Rochester, NYBuilt 1981 · S/N 17274644 N5295ETimbers Flying Club · West Branch, MIFirst renewal noticeBuilt 1978 · S/N 17271824 N5295GJohnston Robert · Hico, TXBuilt 1979 · S/N 17273559 N5295SAlzarqa Saleh A · Fairfax, VABuilt 1970 · S/N 28-26941 N5296BRobertson Ca · Phoenix, AZS/N 1158 N5296KTorres Ruben E · Toa Alta, PRBuilt 1980 · S/N 17274050 N5296PFlanagan Robert Howard · Willows, CABuilt 1958 · S/N 24-337 N5296RB&R Aircraft LLC · Wadsworth, OHBuilt 1974 · S/N 17263510 N5297BHughes Shaman · Cedaredge, COBuilt 1956 · S/N 1159 N5297RWaltman Jack J · Forbes, NDBuilt 1974 · S/N 17263511 N5297WTausch Eddie W · Port Aransas, TXS/N 28-348 N5297YBlotsky Jim Darin · Fargo, NDBuilt 1963 · S/N 18-8022 N5298DMorcom Aviation Services Inc DBA · Everett, WABuilt 1979 · S/N 17272500 N5298JBagamaspad Alan M · Reseda, CABuilt 1980 · S/N 17273758 N5298KNew England Aviation LLC · Plainville, CTBuilt 1980 · S/N 17274051 N5298RMurray Wanda Joyce Trustee · Proctor, MTS/N 17263512 N5298TPleasant Valley Aviation Inc · Bellefonte, PABuilt 1972 · S/N 28-7225396 N5298VGeorgia Building Solutions LLC · Cleveland, GABuilt 1980 · S/N 172RG0501 N5298WAim High Aviation LLC · Coral Springs, FLBuilt 1962 · S/N 28-349 N52993Journeys Aviation Inc · Boulder, COBuilt 1981 · S/N 17274654 N5299DPremier Flight Center LLC · Hartford, CTBuilt 1979 · S/N 17272501 N5299LSerafini Ronald S · Murphy, NCS/N 28-4601 N5299SRichard Douglas G · Decatur, TXBuilt 1970 · S/N 28-26744 N5299WPatterson Guy R Jr · Glencoe, KYBuilt 1962 · S/N 28-350 N529CANeufeld Don I · Fairview, OKS/N 17269104 N529FLSchwanfelder Patrick K · Clinton, CTBuilt 1971 · S/N 28-7125356 N529LFEnterprise Aviation Services LLC · Albuquerque, NMBuilt 1976 · S/N 17267970 N529MCRhoads Eric S · Costa Mesa, CABuilt 1981 · S/N 17274639 N529RBBusby Ralph H III Trustee · Newport, ORBuilt 1960 · S/N TD-417 N529SWFrick Kurtis W · Larned, KSBuilt 1973 · S/N 28-7305450 N529TDJohnson Timothy Dean · Walton, KYBuilt 1972 · S/N 17260741 N52AAWebster Patrick Edward · Elk Grove, CABuilt 1975 · S/N MB-760 N52ATPowell Michael R · Anchorage, AKBuilt 1977 · S/N 1003 N52CAAllison Charles L · Park Rapids, MNBuilt 1993 · S/N 1335 N52DKPierson Janice Trustee · Scio, ORBuilt 1975 · S/N DE892 N52DMPetersen Stephanie Ann Trustee · Coronado, CABuilt 1963 · S/N E3B-624-2224

Back to AD 79-10-03 R2