Registered aircraft · 40,473

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:80-04-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:80-04-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:80-04-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:80-04-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:80-04-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:80-04-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.

N66WNMeyer Robert J · Canyon, TXBuilt 1986 · S/N 232 N67000Registration Pending · Johns Island, SCRegistration pendingS/N ME-283 N6700CKelly Aviation & Investigation LLC · Vail, AZBuilt 1980 · S/N ME-275 N6700FRunels Thomas L · Battle Creek, MIBuilt 1976 · S/N 28-7790161 N6700HNashua Flyers Inc · Nashua, NHBuilt 1975 · S/N 17265543 N67010Robinson Helicopter Company Inc · Torrance, CABuilt 1975 · S/N 0001 N67013Del Ag Aero LLC · Milton, DEBuilt 1979 · S/N M-2229 N6701JJones Bob J Trustee · Littleton, COBuilt 1968 · S/N 28-24395 N6701NFreeman Alan M · San Antonio, TXS/N 680040 N6701RAirplane And Drone Flight Instruction LLC · Orlando, FLBuilt 1980 · S/N ME-281 N6701TAtlanta Aviation Academy Inc · Lawrenceville, GABuilt 1980 · S/N ME-285 N6701VHub City Aviation Academy LLC · Lubbock, TXBuilt 1979 · S/N ME-297 N67022Mccormack James · Mount Jewett, PABuilt 1970 · S/N 17259032 N6702DMcwilliams Christopher S · Atlanta, GABuilt 1979 · S/N M-2231 N6702HGoetz Terry L · Defiance, IABuilt 1975 · S/N 17265545 N6702JWaldron Michelle M · Saranac, NYBuilt 1968 · S/N 28-24397 N6702NRoman Jose Ernesto · Guaynabo, PRBuilt 1968 · S/N 680080 N6702UKruse Benjamin · Phoenix, AZS/N 2434 N6703SSilverhawk Aviation Academy LLC · Caldwell, IDBuilt 2004 · S/N 3621 N6704DScaled Composites LLC · Mojave, CABuilt 1980 · S/N ME-325 N6704EWings Over Texas Holdings LLC · Denton, TXBuilt 1978 · S/N 17272052 N6704JRussell John T · Southaven, MSBuilt 1979 · S/N M-2238 N6704LSoflo Aviation LLC · Oakland Park, FLBuilt 1979 · S/N M-2240 N6704NBethel William C · Murray, KYBuilt 1968 · S/N 680081 N6705JDuncan William E · Troy, IDBuilt 1968 · S/N 28-24400 N6705NGerback Andrew · East Canton, OHBuilt 1968 · S/N 680042 N6706BZvacek Dennis E Trustee · Tulsa, OKBuilt 1956 · S/N 22-4038 N6706HDairy Air Inc · Wyoming, PABuilt 1975 · S/N 17265547 N6706NKorn Richard Mark · Lexington Park, MDBuilt 1968 · S/N 680082 N6706YSorbi Aviation Inc · El Cajon, CABuilt 1979 · S/N ME-299 N6707HWjt Investments LLC · Gurley, ALBuilt 1975 · S/N 17265548 N6707NRegistered aircraftBuilt 1968 · S/N 680043 N6707XGromack Stephen · Bloomfield, NMBuilt 1980 · S/N M-2241 N6708BHartman Darrell W · Fish Lake Valley, NVBuilt 1956 · S/N 22-4041 N6708NBobby Stephen M · Dunkirk, MDBuilt 1979 · S/N M-2243 N6708PWest Robert S · Gravois Mills, MOBuilt 1960 · S/N 24-1834 N6708RStorey Timothy J · Camarillo, CABuilt 1980 · S/N M-2244 N6708SWininger Spencer C · Wichita, KSBuilt 1980 · S/N M-2245 N6708UBlaedow Kyle R · Leesville, LAS/N 2440 N6709FMorning Star Transportation Inc · Dardanelle, ARBuilt 1979 · S/N M-2247 N6709PRzewinski Leonard · Wading River, NYBuilt 1960 · S/N 24-1835 N670SBDanles Enterprises LLC · Solvang, CABuilt 2001 · S/N 23806 N6710BBarnard Matthew Bryan · Fort Worth, TXBuilt 1980 · S/N M-2246 N6710NJohnson Kenneth W · Pine Bluff, ARBuilt 1968 · S/N 680084 N6710UMonroe Flying Club Inc · Glen Carbon, ILBuilt 1963 · S/N 2442 N6711BJohnson Nathaniel D · Attalla, ALBuilt 1956 · S/N 22-4044 N6711GQuality Aviation Inc · Atlanta, GABuilt 1979 · S/N ME-311 N6711JFirecrest LLC · Holly Springs, MSBuilt 1968 · S/N 28-24408 N6711NHanna William R · Castle Rock, COBuilt 1968 · S/N 680045 N6711UUlassin Kyle B · Corvallis, ORBuilt 1963 · S/N 2443

Back to AD 80-04-03 R2