Registered aircraft · 26,232

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:94-05-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:94-05-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:94-05-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:94-05-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:94-05-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:94-05-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.

N75767Stalker Edward R Jr · Wasilla, AKBuilt 1945 · S/N 14007 N7576BAchamp LLC · Memphis, TNBuilt 1957 · S/N 7FC-79 N7576ETalos Flyers Inc · South Bend, INBuilt 1958 · S/N 7FC-264 N7576MFender Steven D · Baltic, OHBuilt 1959 · S/N 55876 N7576TInfinity Builders LLC · Parker, COBuilt 1959 · S/N 47176 N75777Bronson Dale P · Bargersville, INS/N 1 N7577BWillis James R · Belleview, FLBuilt 1957 · S/N 7FC-80 N7577EOstrich James T · Ocala, FLBuilt 1958 · S/N 7FC-265 N7577MMorrow Scott · Sanbornton, NHBuilt 1959 · S/N 55877 N7577TRoot Franklin L · Staunton, VABuilt 1959 · S/N 47177 N7577XBlusky Aviation LLC · Palmyra, INBuilt 1960 · S/N 17248077 N7578MSjeversen Michael D · Mora, MNS/N 55878 N7578XHamilton Randel L · Quitaque, TXBuilt 1960 · S/N 17248078 N7579EStrand Ronald G · Osceola, WIBuilt 1958 · S/N 7FC-267 N757GBBurr Gary · Wadesboro, NCBuilt 2022 · S/N 4937 N757LCPea Patch Properties LLC · North Hampton, NHBuilt 2008 · S/N AL-1135 N757RATorello Marty A · Port Huron, MIBuilt 1978 · S/N 15279933 N757WKKuersteiner William C · Panacea, FLBuilt 1962 · S/N 17249290 N7580EGhafouri Carly · Murrieta, CABuilt 1958 · S/N 7FC-268 N7580XSorgen Michael A · Corning, NYBuilt 1960 · S/N 17248080 N7581EN7581e LLC · Grand Haven, MIBuilt 1958 · S/N 7FC-269 N7581UOse Leroy B · Thief River Falls, MNS/N 15077748 N7582TJones Todd R · Ozona, TXBuilt 1959 · S/N 47182 N7582XSemchenko Norval K · Max, NDBuilt 1960 · S/N 17248082 N7583BGodin David M · Levant, MEBuilt 1957 · S/N 7FC-86 N7583UMcgilvray Jerry Alan · Clayton, ALBuilt 1975 · S/N 15077750 N7583XGreene Bryan V · Turlock, CABuilt 1960 · S/N 17248083 N7584MPecotte Harry A · Silver City, NMBuilt 1959 · S/N 55884 N75857Teeter Joseph J · Lisbon, OHBuilt 2009 · S/N 857 N7585BNorthern Light Aviation LLC · North Waterboro, MEBuilt 1957 · S/N 7FC-88 N7585DSelf Defense Of New England LLC DBA · Bedford, NHBuilt 1957 · S/N 18-5881 N7585TBustamante Luis E · Longview, TXBuilt 1959 · S/N 47185 N7585UMoody Joshua Michael · Springfield, ORBuilt 1975 · S/N 15077752 N7586BTanner Michael John · Hooksett, NHBuilt 1957 · S/N 7FC-89 N7586MStar Valley Aviation Club LLC · Afton, WYBuilt 1959 · S/N 55886 N75875Schumacher Matthew · Wenatchee, WAS/N 18877 N7587TStreater Stephen · Palm Coast, FLBuilt 1959 · S/N 47187 N7587XBrown Bomber LLC · Missoula, MTS/N 17248087 N7588MRucinski Edward A · Climax, NCS/N 55888 N7588TSale Reported · Orlando, FLSale reported, pending cancellationBuilt 1960 · S/N 47188 N758BBN758bb LLC · Commerce Township, MIBuilt 1945 · S/N 14420 N758VPHorn Jon S · Phoenix, AZBuilt 1980 · S/N R1723397 N7590MLucci Giacinto A Jr · Nashville, MIBuilt 1959 · S/N 55890 N7590TDauteuil Rodney A · Salem, NHBuilt 1959 · S/N 47190 N7590UWilson Bobby L · Murray, KYS/N 15077757 N7591TScamman Glenn O · Topeka, KSBuilt 1960 · S/N 47191 N7591UBarbour Benjamin · Huntersville, NCBuilt 1975 · S/N 15077758 N7592BHotvedt Kyle T · Waupaca, WIBuilt 1961 · S/N 7EC-619 N7592TSouthern Kentucky Aviation LLC · Bowling Green, KYS/N 47192 N7592UMiller Collin · Allen, TXBuilt 1975 · S/N 15077759

Back to AD 94-05-05 R1