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.

N6087JTexas Youth Flight Experience Foundation · Boerne, TXBuilt 1973 · S/N A1500387 N6087RPalmenteri Winston D · Rhome, TXS/N 17253756 N60880Walsh Michael B · Gates, TNBuilt 1969 · S/N 15070641 N60883Dubaj Louis F · Spring Hill, FLBuilt 1969 · S/N 15070644 N60884Norton Keith H · Oro Valley, AZBuilt 1969 · S/N 15070645 N60888Somerville Nicholas · Saint Augustine, FLBuilt 1969 · S/N 15070647 N60889Law Offices Of Shawn A Mcmillan Apc · San Diego, CABuilt 1969 · S/N 15070648 N6088GGreat Lakes Air Ventures LLC · Mason, MIBuilt 1969 · S/N 15071588 N6088RPruette Jason · Oakland, CABuilt 1965 · S/N 17253757 N60892Moyers Steven J · Carrollton, KYBuilt 1969 · S/N 15070650 N60895Donald Williamson · Piedmont, SDBuilt 1969 · S/N 15070652 N60899Flight Services Inc · Headland, ALBuilt 1969 · S/N 15070654 N6089RLeadbetter Roy A · Georgetown, TXS/N 17253758 N609033bs Land Development LLC · Seattle, WABuilt 1969 · S/N 15070657 N6090RPaul Rowe Memorial Airport Association Inc · Kahoka, MOBuilt 1965 · S/N 17253759 N60912Krogh Zachary H · Mc Laughlin, SDBuilt 1969 · S/N 15070663 N60916Webb Hunter · Altamont, UTBuilt 1969 · S/N 15070666 N60919Lassie Lite LLC · Rhinebeck, NYBuilt 1969 · S/N 15070669 N6091GAkin Evrin · Newport Beach, CABuilt 1969 · S/N 15071591 N60926Watson Stephen A · Scottsdale, AZBuilt 1969 · S/N 15070673 N6092GComeau Charles · Brimfield, MABuilt 1969 · S/N 15071592 N6092RBrock Roy C Jr · Pilot Point, TXBuilt 1965 · S/N 17253761 N60930Time Machine LLC · Kailua Kona, HIBuilt 1969 · S/N 15070674 N60938Thomas Michael F · Glennallen, AKS/N 15070679 N6093GCaylin LLC · Wilmington, DEBuilt 1969 · S/N 15071593 N60940O Lazy L Ranch & Farm · Satanta, KSBuilt 1969 · S/N 15070681 N60941Mayo Wilburt E Jr · Landers, CABuilt 1969 · S/N 15070682 N60943Walters William L · Boise, IDBuilt 1969 · S/N 15070684 N60944Brecht Deen R · Golden Valley, NDBuilt 1969 · S/N 15070685 N6094JHyten Mark B · Zionsville, INBuilt 1973 · S/N A1500394 N60950Sattizahn William M · Fredericksburg, PABuilt 1969 · S/N 15070690 N60959Cruz Abdiel Ayala · Ocala, FLBuilt 1969 · S/N 15070697 N6095JWaterman David K · Temple City, CABuilt 1973 · S/N A1500395 N6095RWilbanks James R · Clayton, GABuilt 1965 · S/N 17253764 N60962Barnstormers Inc · Bemidji, MNBuilt 1969 · S/N 15070699 N60967Salyer Robert D · Nashville, TNS/N 15070701 N60968Nelson Gary A · Grand Marais, MNBuilt 1969 · S/N 15070702 N6096GPilot Pros Inc · Miami, FLBuilt 1969 · S/N 15071596 N6096JCurrivan Robert B · Fort Mohave, AZS/N A1500396 N60970Airfrank Inc · Hackensack, NJBuilt 1969 · S/N 15070704 N60976Fly Low Aviation LLC · Smithville, MSS/N 15070709 N6097RBravo Charlie One LLC · Redkey, INBuilt 1965 · S/N 17253766 N60982Taylor Gregory William II · Angels Camp, CABuilt 1969 · S/N 15070714 N60983Jpm Aircraft Leasing LLC · Wilmington, DES/N 15070715 N60988Cluck Charles W · Spring, TXBuilt 1969 · S/N 15070718 N6098JHall David K · State College, PABuilt 1973 · S/N A150-0397 N60995Replogle Thomas J · Redondo Beach, CAFirst renewal noticeBuilt 1969 · S/N 15070721 N6099JVincent David R · Hartley, TXBuilt 1973 · S/N A1500399 N609KYMorrison Neil E · Port Townsend, WABuilt 1967 · S/N R172-0225 N60SSDhone Shridhar · Livermore, CABuilt 1968 · S/N 17257479

Back to AD 72-03-03 R3