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.

N3279USchlafmann Jay R · Mercer, NDBuilt 1963 · S/N 18254679 N3280LDobbertin Thomas E · Redlands, CAS/N 17256180 N3281JRegistration Pending · Oakland, ORRegistration pendingBuilt 1966 · S/N 15065981 N3281LWizna LLC · Boca Raton, FLBuilt 1967 · S/N 17256181 N3281SWright Flyers Club · Huber Heights, OHBuilt 1964 · S/N 18255781 N3282LFranco David F Jr · Santa Rosa, CABuilt 1967 · S/N 17256182 N3282SWest Thomas Edward · Watsonville, CABuilt 1964 · S/N 18255782 N3282TCavu Aircraft Sales & Management Inc · Olyphant, PABuilt 1967 · S/N 17700582 N3283LHill Suzanne L · Edmond, OKBuilt 1967 · S/N 17256183 N3284LWill Clifford S · Grayson, GABuilt 1967 · S/N 17256184 N3284YMonnin Cass C · East Wenatchee, WAS/N 18254284 N3285LDouglass Grant · Rockport, TXBuilt 1967 · S/N 17256185 N3285SCastro Manny H · Tucson, AZBuilt 1964 · S/N 18255785 N3286JJohnson David W · Biwabik, MNS/N 15065986 N3286LEagle Eye Aviation LLC · Meridian, IDBuilt 1967 · S/N 17256186 N3288JSouthern Arkansas University Tech · Camden, ARBuilt 1966 · S/N 15065988 N3288SEpple William E · Roggen, COBuilt 1964 · S/N 18255788 N3288UVetch Rod F · Ranchester, WYBuilt 1963 · S/N 18254688 N32897Mach Point Nine LLC · Phoenix, AZS/N 15065989 N3289SDouble Lazy H LLC · Delta, COBuilt 1964 · S/N 18255789 N3289URutenbeck Terry L · Wiggins, COBuilt 1963 · S/N 18254689 N3289YHasselbring Ted S · Nashville, TNBuilt 1962 · S/N 18254289 N32909Zamarripa Hector · Brownsville, TXBuilt 1970 · S/N 18260423 N3290FCline Mark A · Winston Salem, NCBuilt 1967 · S/N R172-0222 N3290JFitzgerald Jacob J · Pullman, WABuilt 1966 · S/N 15065990 N3291LSun Baron · Arcadia, CABuilt 1967 · S/N 17256191 N3291SRegistration Pending · Highland, ILRegistration pendingBuilt 1964 · S/N 18255791 N3291ZMiller Andy D · Marana, AZBuilt 1973 · S/N 15075105 N3292TCelestial Kinetics Flight Academy LLC · Waupaca, WIBuilt 1967 · S/N 17700592 N3292UAnnecchini Frank C Jr · Overland Park, KSBuilt 1963 · S/N 18254692 N3293YKiedinger John D · Burleson, TXS/N 18254293 N3294TWolniansky Peter W · Ocean Grove, NJS/N 17700594 N3294UWidener Christine A · Tucson, AZBuilt 1963 · S/N 18254694 N3295JClonts Kim E · Knox City, TXS/N 15065995 N3295YReid Brian M · Boise, IDS/N 18254295 N3296SBeekman Steven J · Stephenson, MIBuilt 1964 · S/N 18255796 N3296UBierer David E · Victor, MTBuilt 1963 · S/N 18254696 N3296YBeckord Aaron P · Tacoma, WABuilt 1962 · S/N 18254296 N3297LRaymond Patrick H · Jerseyville, ILBuilt 1967 · S/N 17256197 N3297TBurgdorf Dale A · Plano, TXBuilt 1967 · S/N 17700597 N3297YMust Dash Rides Flying Club LLC · Raleigh, NCBuilt 1962 · S/N 18254297 N3298LThompson Edward E · Buxton, MEBuilt 1967 · S/N 17256198 N3298SHolloway Cody L · Belle Plaine, KSBuilt 1964 · S/N 18255798 N3298T515 Aviation LLC · Dexter, IABuilt 1967 · S/N 17700598 N3299JEdwards Wallace · Commerce, MIS/N 15065999 N3299LHarrington David J · Albuquerque, NMBuilt 1967 · S/N 17256199 N3299SS V Aeronautics LLC · Afton, WYBuilt 1964 · S/N 18255799 N3299TSale Reported · Daytona Beach, FLSale reported, canceledBuilt 1967 · S/N 17700599 N3299URichardson Ronnie L Jr · East Wenatchee, WAFirst renewal noticeBuilt 1963 · S/N 18254699 N329DJBritt Matthew W · Trenton, SCBuilt 1976 · S/N 177RG0845

Back to AD 72-03-03 R3