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.

N22462Organ Daniel W · Vernonia, ORBuilt 1968 · S/N 15068298 N2246JMcmurray Jay C · Niota, TNBuilt 1966 · S/N 15065446 N2246RMontgomery Brian · Houston, TXBuilt 1968 · S/N T210-0396 N2246YHixon Craig D · Sayre, OKBuilt 1967 · S/N 17700046 N22475Ace Aeromotive Inc · Miami, FLBuilt 1968 · S/N 15068306 N22477Ray Erin N · Manor, TXFirst renewal noticeBuilt 1968 · S/N 15068307 N2247JHeathers Houses Foundation Inc · Fort Lauderdale, FLBuilt 1966 · S/N 15065447 N22484Tinoco Joseph I · Shoreline, WABuilt 1968 · S/N 15068310 N22487Skyguard Instruction LLC · Ann Arbor, MIBuilt 1968 · S/N 15068312 N22488Oneal Sean M · Santa Cruz, CABuilt 1968 · S/N 15068313 N22489Sky Walker Flight School LLC · Adrian, MIBuilt 1968 · S/N 15068314 N2248RVan Heemst Jeffrey A · West Palm Beach, FLFirst renewal noticeBuilt 1968 · S/N T210-0398 N2248YDavis Christopher S · Halls, TNBuilt 1967 · S/N 17700048 N22491Yasumiishi Joy Marie Trustee · Juneau, AKS/N 15068316 N22498Evans Thomas G · Dawson, ALS/N 15068318 N22499Johnson Dale B · Steele, NDBuilt 1968 · S/N 15068319 N2249YBlake Bernie E · Troy, NCBuilt 1967 · S/N 17700049 N224ALAirborne Support Group LLC · Marion, MTBuilt 1963 · S/N 2050342 N224MBBarker Ballard M · Satellite Beach, FLBuilt 1976 · S/N 177RG0935 N22501Smith Dylan Lane · Oklahoma City, OKBuilt 1968 · S/N 15068321 N2250JLuce Frederick M · Brookshire, TXBuilt 1966 · S/N 15065450 N22515Wheeler Bret · La Grande, ORBuilt 1968 · S/N 15068329 N22523Beene Donald L · Westfield, INBuilt 1968 · S/N 15068334 N22526Staloff Jason A · Greenfield, MABuilt 1968 · S/N 15068337 N22528Hhd Aviation LLC · Hamilton, OHBuilt 1968 · S/N 15068339 N22529Rhodes Stephen D · Hendersonville, NCS/N 15068340 N2252RStout Walt · White Hills, AZBuilt 1968 · S/N T210-0402 N2252YMeisch Robert L · Crystal, MNBuilt 1967 · S/N 17700052 N22533Regner Mark W · Danbury, CTBuilt 1968 · S/N 15068343 N22536Reep Jennifer B · Stone Mountain, GABuilt 1968 · S/N 15068345 N22537Ernst Albert S III · Buda, TXS/N 15068346 N2253YAviation 2000 Inc · Fort Mill, SCBuilt 1967 · S/N 17700053 N22540Mcgovern Thomas F · Blue Springs, MOBuilt 1968 · S/N 15068347 N22542Apgyn And Associates Inc · Coral Springs, FLBuilt 1968 · S/N 15068349 N22544N1705r Inc · Cobb, CAS/N 15068351 N22556Rawareo LLC · Warsaw, MOS/N 15068359 N22558Lilik Dennis A · Lewes, DEBuilt 1968 · S/N 15068360 N22561Buckley Holli R · Columbia, MSBuilt 1968 · S/N 15068362 N22563Davis Michael A Jr · Fairbanks, AKBuilt 1968 · S/N 15068364 N22564Darnell Stephen L · Bargersville, INBuilt 1968 · S/N 15068365 N22568Pina Gabriel B · Pasadena, CABuilt 1968 · S/N 15068368 N22570Nebbia Valter Della · Archer City, TXBuilt 1968 · S/N 15068369 N22582Lee Scott M · Noble, OKBuilt 1968 · S/N 15068376 N22583Christensen Marc G · Bountiful, UTBuilt 1968 · S/N 15068377 N22584Manning Christopher S · Dawson, GABuilt 1968 · S/N 15068378 N22585Obregon Aviation LLC · San Francisco, CABuilt 1968 · S/N 15068379 N22586Weyker William J · Rhinelander, WIBuilt 1968 · S/N 15068380 N22589Robles Lazaro R · Golden Valley, MNBuilt 1968 · S/N 15068383 N2258YConnor Thomas M · Great Falls, MTBuilt 1967 · S/N 17700058 N22590Sorensen Dale · Wellsville, UTS/N 15068384

Back to AD 72-03-03 R3