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.

N18155Willis Nathan Eric · Broken Arrow, OKBuilt 1972 · S/N 15073828 N18157Matz Robert D · Niles, MIBuilt 1972 · S/N 15073830 N18159Beck Thomas G · Walled Lake, MIBuilt 1976 · S/N 17702534 N18162Pruzek Richard L · Chippewa Falls, WIBuilt 1972 · S/N 15073834 N18163Wings Aero LLC · Zeeland, MIBuilt 1972 · S/N 15073835 N18164Cendejas Agustin · Chino, CABuilt 1972 · S/N 15073836 N18167Be Chara Niz Ar E · Columbia, MDBuilt 1972 · S/N 15073838 N1816FMalcom Scott O · Toledo, WABuilt 1965 · S/N 21058716 N1816QS And E Airplane Company · Puyallup, WABuilt 1971 · S/N 177RG0216 N18171Isaacson Arthur T · Hillsboro, MOS/N 15073840 N18173Bb Aero Works Ltd · Whitehouse, OHBuilt 1972 · S/N 15073842 N18174Connell William J · Woodinville, WABuilt 1976 · S/N 17702535 N18177Hoffman Rick W · Elk River, MNBuilt 1972 · S/N 15073846 N1817QJohnston Bernard D · Puyallup, WAFirst renewal noticeBuilt 1971 · S/N 177RG0217 N1817XSale Reported · Roseville, MNSale reported, pending cancellationBuilt 1965 · S/N 18255917 N18180Woodward Aviation · Varnville, SCS/N 15073847 N18189Jaam-A LLC · Matthews, NCBuilt 1972 · S/N 15073852 N18197C150 Holdings LLC · Newark, DEBuilt 1972 · S/N 15073854 N18198Ohare Douglas K · Ainsworth, NEBuilt 1972 · S/N 15073855 N18199Forthman Scott Chance · Miami, FLBuilt 1972 · S/N 15073856 N1819QSchmidt Mark · San Jose, CABuilt 1971 · S/N 177RG0219 N1819XGrant Steven T · Sellers, SCBuilt 1964 · S/N 18255919 N181CPEighty1 Aviation LLC · Canton, GABuilt 1964 · S/N 18255766 N181DHWinkler Jeffery L · Brush, COBuilt 1964 · S/N 206-0220 N181TTWilson James · Bagwell, TXBuilt 1964 · S/N 17252385 N181VVScriva Jennifer L · Sherwood, ARBuilt 1966 · S/N 15065010 N18200Morristown Flying Service Inc · Talbott, TNBuilt 1972 · S/N 15073857 N18201Anderson William T · Pine Bluff, ARBuilt 1972 · S/N 15073858 N18202Flying Tomato Aviation LLC · Medina, OHBuilt 1972 · S/N 15073859 N18208Ivy James E · Alba, TXS/N 15073863 N1820ZStaats Douglas E · Anchorage, AKBuilt 1962 · S/N 205-0020 N18210Aircraft Construction Specialist Inc · Collinsville, OKBuilt 1972 · S/N 15073865 N18213Diek Mondo R · Stevenson, WABuilt 1972 · S/N 15073867 N1821FAlexander Travis · Hudson Oaks, TXS/N 21058721 N1821QPamperien Casey Dean · Manassa, COBuilt 1971 · S/N 177RG0221 N1821SBailey Ralph E · Sikeston, MOBuilt 1962 · S/N 2050021 N1821XCluer Brian L · Bodega, CABuilt 1964 · S/N 18255921 N18222Baxter Paul A · Logandale, NVBuilt 1972 · S/N 15073876 N18225Cosentino Allen P · Templeton, MABuilt 1972 · S/N 15073878 N18226Filler Joseph J · Wyoming, PABuilt 1976 · S/N 17702537 N18229Fluno John I · San Anselmo, CABuilt 1972 · S/N 15073882 N1822QPopiol Victor · Doral, FLBuilt 1971 · S/N 177RG0222 N1822ZAhrens Kevin Michael · Cashmere, WABuilt 1962 · S/N 205-0022 N18233Geiger Kurtis · Visalia, CABuilt 1972 · S/N 15073886 N18234Nance David B · Quinton, VABuilt 1972 · S/N 15073887 N1823XN1823x LLC · Middletown, DEBuilt 1964 · S/N 18255923 N1824AVesper David G · Ashland, OHBuilt 1970 · S/N 18260221 N1825ZGreentek Inc · Oroville, CABuilt 1962 · S/N 205-0025 N18266Underwood Gary · Lewisville, TXBuilt 1966 · S/N 18257115 N1826QMiller Brent R · Orefield, PABuilt 1971 · S/N 177RG0226

Back to AD 72-03-03 R3