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.

N3604JSmtm Holdings Inc · Wilmington, DES/N 15064904 N3605JBon Investment Holdings LLC · Zephyrhills, FLBuilt 1966 · S/N 15064905 N3605LUnger Aviation LLC · Saint Clair, MIBuilt 1965 · S/N 17253774 N3606JElite Fleet Jacksonville LLC · Jacksonville, FLBuilt 1966 · S/N 15064906 N3607JSmith Zachary L · Piedmont, SCBuilt 1966 · S/N 15064907 N3607UHastings Flyers LLC · Hastings, NES/N 18255007 N3608JSwartzentruber Thomas L · Oakland, MDBuilt 1966 · S/N 15064908 N3608LJ P Aero Holdings Inc · Carson City, NVS/N 17253777 N3608URegistration Pending · Homer, AKRegistration pendingBuilt 1963 · S/N 18255008 N360MWMission Wings International Inc · Salem, OHS/N P206-0572 N360RJOliver Paul D · Bozeman, MTBuilt 1964 · S/N 206-0225 N3611JShannon James P · Vandergrift, PABuilt 1966 · S/N 15064911 N3611LVick Garland L · Benton, ARBuilt 1965 · S/N 17253780 N3612LClean Waste Solutions LLC · Indianapolis, INBuilt 1965 · S/N 17253781 N3613JBatista Brasil Vagner · Orlando, FLBuilt 1966 · S/N 15064913 N3613UN3613u LLC · Lakeland, FLBuilt 1963 · S/N 18255013 N3614JSikveland Beau D · Circle, MTBuilt 1966 · S/N 15064914 N3614LHarris Danny R · Winnsboro, TXBuilt 1965 · S/N 17253783 N3614UT Yowonske Enterprises LLC · Rostraver Township, PAS/N 18255014 N3615LEynon Thomas Elliott · North Royalton, OHS/N 17253784 N3616JB&R Aircraft LLC · Wadsworth, OHBuilt 1966 · S/N 15064916 N3616LSoflair Aviation Solutions LLC · Miami, FLS/N 17253785 N3616UHatch Koay A · Gilbert, AZBuilt 1963 · S/N 18255016 N3617JShowalter Steven L · Goshen, INBuilt 1966 · S/N 15064917 N3618JWright David G · Lake Oswego, ORBuilt 1966 · S/N 15064918 N3620JBerens Eric A · Stevens Point, WIBuilt 1966 · S/N 15064920 N3620LMullins Lawrence D · Germantown, OHBuilt 1965 · S/N 17253789 N36213N36213 Aircraft Ownership LLC · The Woodlands, TXBuilt 1975 · S/N 17702240 N3621JLow Cost Flying LLC · Chandler, AZBuilt 1966 · S/N 15064921 N3621UStewart Gary T · Friendswood, TXBuilt 1963 · S/N 18255021 N3622LStrelzik Raymond W · Hatfield, PABuilt 1965 · S/N 17253791 N3622UDegonia Gerald · Plainfield, ILBuilt 1963 · S/N 18255022 N3624UWilkinson Larry G · Henderson, NVBuilt 1963 · S/N 18255024 N3625LWilliams Michael R · Gig Harbor, WABuilt 1965 · S/N 17253794 N3626JEa Cvg LLC · Erlanger, KYS/N 15064926 N3626LKoshar Robert E · Watervliet, MIBuilt 1965 · S/N 17253795 N3627LGeorge Edward J · Highland Village, TXBuilt 1965 · S/N 17253796 N3627UStribling Tyron S · Lagrange, GABuilt 1963 · S/N 18255027 N3628JLucarelli David L · Moncks Corner, SCBuilt 1966 · S/N 15064928 N3628LThrasher Gary Phillip · Galena, OHBuilt 1965 · S/N 17253797 N362CAChoice Aviation LLC · Hamilton, MTBuilt 1970 · S/N 17258976 N362KWFliteco Holdings LLC · Lewes, DES/N 18260338 N3631LMcveigh Ian T · Mansfield, TXS/N 17253800 N3631UBurden Richard M · Woodway, TXBuilt 1963 · S/N 18255031 N3632JMitterling Richard H · Boothbay Harbor, MEBuilt 1966 · S/N 15064932 N3632LInternational Life Equity Group LLC · Columbia, KYBuilt 1966 · S/N 17253801 N3633JMicrokit Solutions LLC · Bridgeview, ILS/N 15064933 N3633UBrasher Cecil V Jr · Jamestown, NCBuilt 1963 · S/N 18255033 N3634JLuft Inc · North Fort Myers, FLBuilt 1966 · S/N 15064934 N3634LWahlberg Randy A · Pearland, TXBuilt 1965 · S/N 17253803

Back to AD 72-03-03 R3