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.

N9984VValley Drug Of Malta Inc · Malta, MTBuilt 1974 · S/N 17264602 N9984WBlake David R · Sheridan, WYBuilt 1967 · S/N 28-23532 N9985BJacks Charles D · Morse, LABuilt 1982 · S/N 172RG1107 N9985DTrimmer Marvin E · Willow, AKBuilt 1959 · S/N 22-6777 N9986CLawrence Oakes K III · Newfields, NHS/N 241 N9986DWalsh Arthur B · Lincoln, NERegistration revokedBuilt 1959 · S/N 226778 N9986SKaneaster Richard W · Port Orange, FLBuilt 1996 · S/N 1218-96 N9988RSanders Flight Training Center Inc · Jasper, ALBuilt 1960 · S/N TD-407 N9988VLenoir Aviation Club Inc · Lenoir, NCFirst renewal noticeBuilt 1974 · S/N 17264606 N9988WHanneman Michael W · Abilene, TXBuilt 1968 · S/N 28-24838 N9989VPace Dusty · Pendleton, ORBuilt 1974 · S/N 17264607 N9989WDnr Solutions LLC · Idaho Falls, IDBuilt 1967 · S/N 28-23537 N998CCBecker Mike DBA · La Grande, ORBuilt 2000 · S/N 9916CC N998NCHoppe Joel A · Fort Myers, FLBuilt 1964 · S/N 250 N998RASchubert Brothers Aviation Inc · Canandaigua, NYBuilt 1973 · S/N 17261672 N998SEUtter Albert · Fort Myers, FLBuilt 1988 · S/N 17274025 N9990BAurora-Flight LLC · Commerce Township, MIBuilt 1982 · S/N 172RG1109 N9990CFogarty Stephen J · Wasilla, AKBuilt 1958 · S/N 245 N9990VCompass Aviation Inc · Shelby, NCBuilt 1974 · S/N 17264608 N99917Anderson Cody Jon · Orono, MEBuilt 1986 · S/N 17276527 N9991BTaft Leasing LLC · Bloomfield, NMBuilt 1982 · S/N 172RG1110 N9991DNothum Robert G · Dixon, MOBuilt 1959 · S/N 22-6783 N9991GSale Reported · Staten Island, NYSale reported, canceledBuilt 1979 · S/N 17273639 N9991VSafeway Flying Club Inc · Denmark, WIBuilt 1975 · S/N 17264609 N9992VShipe Jacqueline M · Louisville, TNBuilt 1974 · S/N 17264610 N9993DMunson Matthew C · Canby, ORBuilt 1959 · S/N 22-6786 N9993ECruise Flight Academy Inc · Dalton, GABuilt 1979 · S/N 17272309 N99948Florida State College At Jacksonville · Jacksonville, FLS/N 172-76483 N9994DKnudsen Ernest W Jr · Ennis, TXBuilt 1959 · S/N 22-6787 N9994UKaczmarek John F · Weatherford, TXBuilt 1977 · S/N AA5A0394 N9994VWings Over Texas Holdings LLC · Denton, TXBuilt 1974 · S/N 17264612 N9995CCullman Dan H · Kent, WABuilt 1959 · S/N 250 N9995UAero Cats Of New Hampshire LLC · Plainfield, NHBuilt 1977 · S/N AA5A0395 N9996CHackwell Calvin · Enoch, UTBuilt 1959 · S/N 251 N9996USapir Kfir · Las Vegas, NVBuilt 1977 · S/N AA5A0396 N9997UGuth Giora · Lexington, MABuilt 1977 · S/N AA5A0397 N9997VBecker Philip J · Ocean Isle Beach, NCBuilt 1974 · S/N 17264614 N9997YLehrer James R · Thief River Falls, MNBuilt 1964 · S/N 194 N99981Sky High Leasing Services LLC · Lakeland, FLBuilt 1985 · S/N 17276533 N9998DHarkins Cody · Grover, WYS/N 22-6791 N9998RSkyview Aviation LLC · Benton, KYBuilt 1960 · S/N TD-428 N99991Genovese Mark A · Baltimore, MDBuilt 1985 · S/N 17276534 N9999ALake Mark S · Erie, COBuilt 1955 · S/N 22-2842 N9999DAnderson Corlin L · North Branch, MNBuilt 1959 · S/N 22-6792 N9999UMcgee Allen C · Charlotte, NCBuilt 1977 · S/N AA5A0399 N999AFThree Four Juliet LLC · Orange, CABuilt 1975 · S/N 17265806 N999ARD R Tripp Enterprises LLC · Omaha, NES/N 17268006 N999BATeslow Timothy W · Fairbanks, AKBuilt 1977 · S/N 18-7709138 N999CLCollette Dean R · Effingham, ILBuilt 1970 · S/N 28-5829 N999EDAero Design Works LLC · Ormond Beach, FLBuilt 1975 · S/N AA5B-0188

Back to AD 79-10-03 R2