Skip to content

Registered aircraft · 17,028

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.

N8234URegistered aircraftBuilt 1964 · S/N 17252134 N8235GSterling Colleen M Trustee · El Cajon, CABuilt 1971 · S/N 177RG0135 N8235ULind Gerald Wayne · Oakley, IDS/N 17252135 N8236LCiroli Kenneth E · Indiana, PAFirst renewal noticeBuilt 1967 · S/N 17256436 N8237GRegistered aircraftBuilt 1971 · S/N 177RG0137 N8237SArth Richard E · Newcomerstown, OHBuilt 1965 · S/N 15061837 N8237UNo Money For Plane LLC · Grand Rapids, MIBuilt 1964 · S/N 17252137 N8238GDavison Dennis D · Spanaway, WABuilt 1971 · S/N 177RG0138 N8238UPowers Robert · Iowa City, IABuilt 1964 · S/N 17252138 N8239FTeeters Larry N · Shreveport, LABuilt 1966 · S/N 15064339 N8239LSkys Edge Aviation LLC · Midland, TXBuilt 1967 · S/N 17256439 N8239ZWard James H Jr · Plymouth, NCS/N 205-0239 N823FStout Philip L · Ephrata, WAS/N 15064514 N823WSMcinturf Paul A Jr · Childress, TXBuilt 1967 · S/N 15066175 N8240F14a Flying Club Inc · Mooresville, NCBuilt 1966 · S/N 15064340 N8240LCactus To Clouds Aviation LLC · Indio, CABuilt 1967 · S/N 17256440 N8240ZSingleton Shermann S · Farmington, NMS/N 205-0240 N8241GSilvers Clarence W III · Holden, MOBuilt 1971 · S/N 177RG0141 N8241MVenema-Ashmore Karin · East Dixfield, MEBuilt 1969 · S/N 21059241 N8241URegistration Pending · Casa Grande, AZRegistration pendingBuilt 1964 · S/N 17252141 N8242GValdez Acela Rangel · Maricopa, AZS/N 177RG0142 N8243GGebauer David Lee · Jackson, CABuilt 1971 · S/N 177RG0143 N8243ZHogscanfly LLC · Wagner, SDBuilt 1963 · S/N 205-0243 N8244GHughes Jeffrey D · Roseburg, ORBuilt 1971 · S/N 177RG0144 N8245FMorisette Michael W · Antelope, CABuilt 1966 · S/N 15064345 N8245GSchultz Jeffrey R · Dayton, OHBuilt 1971 · S/N 177RG0145 N8245ZByrum Scott L · Avondale, AZBuilt 1963 · S/N 205-0245 N8246FTalikka Todd · Paulding, OHBuilt 1966 · S/N 15064346 N8246LPatak Eva L · Ennis, TXBuilt 1967 · S/N 17256446 N8246ZChak Chak LLC · White Salmon, WABuilt 1963 · S/N 205-0246 N8247FCarson Leonard H · Chesapeake, VAS/N 15064347 N8247LKnepp Terry · Montgomery, INBuilt 1967 · S/N 17256447 N8247UComeau Paul D · Walden, NYBuilt 1964 · S/N 17252147 N8247ZBeam Troy A Trustee · Shippensburg, PABuilt 1963 · S/N 205-0247 N82488Simpson Patrick E · Ketchum, IDBuilt 1964 · S/N 18255745 N8248FLucia Steven R Sr · Agawam, MAS/N 15064348 N8248GSchuster Peter E · Dundee, OHBuilt 1971 · S/N 177RG0148 N8248LBattleshaw Raymond · Weidman, MIBuilt 1967 · S/N 17256448 N8248URobison Wm Lee · Smithville, MOBuilt 1964 · S/N 17252148 N8249UDracka Charles L · Port Clinton, OHS/N 17252149 N8250FRyan Good Aviation LLC · Sioux Falls, SDS/N 15064350 N8250LStieler David C · Marlette, MIBuilt 1967 · S/N 17256450 N8250SRegistration Pending · Statesville, NCRegistration pendingBuilt 1965 · S/N 15061850 N8250UCalderon Daniel · Orlando, FLS/N 17252150 N8251ZGarner Charlotte Trustee · Sun Lakes, AZBuilt 1963 · S/N 205-0251 N8252LSky And Summit Aviation LLC · Suwanee, GABuilt 1967 · S/N 17256452 N8252MApplied Olap Inc · Huntsville, ALBuilt 1969 · S/N 21059252 N8253FSinclair Jerry D · Watonga, OKBuilt 1966 · S/N 15064353 N8253GHudson Allen N · Bowling Green, KYS/N 177RG0153 N8253LKostroski Larry J · Tucson, AZBuilt 1967 · S/N 17256453

Back to AD 72-03-03 R3