Skip to content

Registered aircraft · 17,027

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:72-03-03-R3') OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:72-03-03-R3') 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:72-03-03-R3')
    OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:72-03-03-R3')
  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:72-03-03-R3')
  OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:72-03-03-R3')
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.

N3257YGilbert Donald L Jr · Ligonier, PABuilt 1962 · S/N 18254257 N3258SRockwood Spa LLC · Houston, MOBuilt 1964 · S/N 18255758 N3258YByra Paula A · Pagosa Springs, COS/N 18254258 N3259JPreflight Aviation Inc · Oregon, WIBuilt 1966 · S/N 15065959 N3259UMoore Christopher · Canton, PABuilt 1963 · S/N 18254659 N3259YGrantham William Edward · Doerun, GAS/N 18254259 N3260LHerring Rhett H · College Station, TXBuilt 1967 · S/N 17256160 N3260SAbner Aviation LLC · Advance, NCS/N 18255760 N3260YOneal Gary · Springdale, ARBuilt 1962 · S/N 18254260 N3261SBig Island Gravity LLC · Kapaau, HIS/N 18255761 N3262JBlock Oliver L · Nashville, TNS/N 15065962 N3262LKd3262 LLC · Downers Grove, ILBuilt 1967 · S/N 17256162 N3262SIlair LLC · Manassas, VABuilt 1964 · S/N 18255762 N3263LSale Reported · Arcata, CASale reportedBuilt 1967 · S/N 17256163 N3263SBynum Albert L · Gadsden, ALBuilt 1964 · S/N 18255763 N3264JB&K Used Auto & Equipment Llp · Fountain Run, KYBuilt 1966 · S/N 15065964 N3264TVan Iderstyne Richard D · Jekyll Island, GABuilt 1967 · S/N 17700564 N3265JFord-Umfuhrer Austin Donavan · Carrollton, GAS/N 15065965 N3265SZehntner David R · Labelle, FLBuilt 1964 · S/N 18255765 N3265UPreissler Daniel E · Giltner, NEBuilt 1963 · S/N 18254665 N3266LWolverine LLC · Roanoke, VABuilt 1967 · S/N 17256166 N3266UVingers Michael T · Dellwood, MNBuilt 1963 · S/N 18254666 N3267LBetter Fly Inc · Litchfield, ILS/N 17256167 N3268JMiller Robert F · Locust Grove, GAS/N 15065968 N3268KRegistered aircraftBuilt 1968 · S/N 17700519 N3268SSquier Mark R · Lake Dallas, TXBuilt 1964 · S/N 18255768 N3268TKawsara Sabah M · Fort Worth, TXBuilt 1967 · S/N 17700568 N3270UScott Brian W · Sagle, IDBuilt 1963 · S/N 18254670 N3271LHenson Raul Andre · Fox Island, WABuilt 1967 · S/N 17256171 N3271UDallas Avionics Inc · Dallas, TXBuilt 1963 · S/N 18254671 N3271YWoodbury Ivan D · Bowling Green, OHBuilt 1962 · S/N 18254271 N3272TSonoras John G Jr · Newport, MIBuilt 1967 · S/N 17700572 N3272YOlsen Chris M · Othello, WAS/N 18254272 N3273SHepfer John E DBA · Midland, TXBuilt 1964 · S/N 18255773 N3273TSommers Bradley D · Robinson, KSBuilt 1967 · S/N 17700573 N3274JOgrady John Thomas · West Chicago, ILBuilt 1966 · S/N 15065974 N3274LHk Ventures LLC · Paynesville, MNS/N 17256174 N3274TRinkle Michael G · Sussex, NJBuilt 1967 · S/N 17700574 N3275LMil2atp Inc · Pikeville, NCBuilt 1967 · S/N 17256175 N3276SLewinsky Marlon · Carrollton, TXBuilt 1964 · S/N 18255776 N3276UNk Innovations LLC · Spokane, WABuilt 1963 · S/N 18254676 N3277JBranson William E · Stokesdale, NCBuilt 1966 · S/N 15065977 N3277LDeshpande Peter N · Eugene, ORBuilt 1967 · S/N 17256177 N3277SBayless Smoky · Coronado, CABuilt 1964 · S/N 18255777 N3277YLapinsky Richard G · Los Lunas, NMBuilt 1962 · S/N 18254277 N3278JSarrafi Frank H · Tarzana, CABuilt 1966 · S/N 15065978 N3278LPeterson Donald A · Ajo, AZBuilt 1967 · S/N 17256178 N3278SStrong Brian S · Southport, NCBuilt 1964 · S/N 18255778 N3278UCarver Thomas G · St Maries, IDBuilt 1963 · S/N 18254678 N3279LDomnarski Michael J · Ware, MABuilt 1967 · S/N 17256179

Back to AD 72-03-03 R3