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.

N92215Indian Lakes Aviation LLC · Cedar Springs, MIBuilt 1969 · S/N 18260095 N9221XBoettger Gordon R · Carson City, NVBuilt 1961 · S/N 18253621 N9222Erkmann Christopher R Trustee · Chesterfield, MOBuilt 1962 · S/N 18254216 N9222CHall Vincent P · San Diego, CAS/N 205-0327 N9222XJones Margaret C · San Marcos, TXFirst renewal noticeBuilt 1961 · S/N 18253622 N9223GWilson John L · Winchester, KYBuilt 1971 · S/N 18260763 N9224GB9224g LLC · Carthage, NCBuilt 1971 · S/N 18260764 N9225XMenix Travis L · Russell Springs, KYBuilt 1961 · S/N 18253625 N92262William Syme Alexander Howie Trustee · Bozeman, MTBuilt 1969 · S/N 18260117 N92265Futchagribusiness LLC · Broxton, GABuilt 1969 · S/N 18260119 N9226GLefevre Jonathan W · Haskell, TXBuilt 1971 · S/N 18260766 N9226XJjm3 LLC · Twin Falls, IDS/N 18253626 N92277Whiskey Bravo Investments LLC · Bulverde, TXBuilt 1969 · S/N 18260125 N92280Look To The Sky LLC · Middletown, DEBuilt 1969 · S/N 18260126 N92281Jera Aviation LLC · Brooksville, FLBuilt 1969 · S/N 18260127 N92282Registered aircraftBuilt 1969 · S/N 18260128 N92286Wpr Group LLC · Clinton, MSBuilt 1969 · S/N 18260130 N9228GDouthitt Kevin S · Long Bch Twp, NJBuilt 1971 · S/N 18260768 N92291Media Stew LLC · Carson City, NVBuilt 1969 · S/N 18260132 N92298Ponderosa Aviation LLC · Safford, AZBuilt 1969 · S/N 18260137 N92299Barxbar Aviation LLC · Mesa, AZBuilt 1969 · S/N 18260138 N9229GKhademi Amin · Chino Hills, CABuilt 1971 · S/N 18260769 N922VBPilotwire LLC · Argyle, TXFirst renewal noticeBuilt 1968 · S/N 18258924 N92311Delorenzo Thomas H · Nazareth, PABuilt 1969 · S/N 18260145 N92316Caldwell Kevin M · Camano Island, WABuilt 1969 · S/N 18260146 N9231GJock Carl · Roscommon, MIBuilt 1971 · S/N 18260771 N9231XPrelesnick Tony · Claremore, OKBuilt 1961 · S/N 18253631 N92323Tarandi Leasing Inc · Oswego, NYS/N 18260151 N92329Gorski Stephen · Sarasota, FLBuilt 1969 · S/N 18260155 N9232XRamirez Martin · Rockwall, TXBuilt 1961 · S/N 18253632 N92331Global Business Concept LLC · Newton, MABuilt 1969 · S/N 18260157 N92335Steinle Michael · Lake Village, INBuilt 1969 · S/N 18260158 N92336Chiatovich Larry R · Grandview, WABuilt 1969 · S/N 18260159 N9233GSchaffitzel Mark · Owasso, OKBuilt 1971 · S/N 18260773 N92340Jerrett Lamont · Chino Hills, CABuilt 1969 · S/N 18260161 N92341Registration Pending · Wanchese, NCRegistration pendingBuilt 1969 · S/N 18260162 N92344Mastley William T · Reno, NVBuilt 1969 · S/N 18260164 N92346305 Sky LLC · Boca Raton, FLBuilt 1969 · S/N 18260166 N9234GGodlevsky Leslie · Hot Springs, SDBuilt 1971 · S/N 18260774 N9235189th Marin Aerosquadron Inc · San Francisco, CAS/N 18260167 N92353Silver Wings Flying Club · Los Gatos, CABuilt 1969 · S/N 18260168 N92359Schmick Kenneth R · Fond Du Lac, WIS/N 18260171 N92386Lee Eric H · San Diego, CABuilt 1969 · S/N 18260180 N9238GSprang Pamela G · Newnan, GABuilt 1971 · S/N 18260778 N92399Hyland Flyers Inc · Coon Rapids, MNBuilt 1969 · S/N 18260185 N9239XCarroll Bodo W · Franklin, OHBuilt 1962 · S/N 18253639 N923BRWings Of Grace Ministries Inc · Melbourne, FLBuilt 1967 · S/N 15067181 N923STThompson Michael J · Nine Mile Falls, WABuilt 1963 · S/N 2050313 N92405Burgess Brian Keith · Arnoldsville, GABuilt 1969 · S/N 18260187 N92406Anderson George C · Centerville, UTBuilt 1969 · S/N 18260188

Back to AD 72-03-03 R3