Skip to content

Registered aircraft · 25,369

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:80-25-07-R1') OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:80-25-07-R1') 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:80-25-07-R1')
    OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:80-25-07-R1')
  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:80-25-07-R1')
  OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:80-25-07-R1')
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.

N733UEWings Over Texas Holdings LLC · Denton, TXS/N 17268552 N733UFReid Dennis · Vinemont, ALBuilt 1977 · S/N 17268553 N733UGHoffman Thomas A Trustee · Emmett, KSBuilt 1977 · S/N 17268554 N733UJEngelhard Edward L · Hatfield, PABuilt 1977 · S/N 17268556 N733UNRugh Gene A · Wright City, MOS/N 17268560 N733UTOmartian Robert A · Simsbury, CTBuilt 1977 · S/N 17268565 N733VADrane Kenneth · Natchez, MSBuilt 1977 · S/N 17268572 N733VFGillen Scott E · San Diego, CABuilt 1977 · S/N 17268577 N733VGFrevert Darwin C · Highland Village, TXBuilt 1977 · S/N 17268578 N733VHAerospace Testing Engineering & Certification Inc · Seattle, WABuilt 1977 · S/N 17268579 N733VJLura Aaron P · Carrington, NDBuilt 1977 · S/N 17268580 N733VLYuma Ag Service Inc · Yuma, COBuilt 1977 · S/N 17268582 N733VRLegends Air Center LLC · Bentonville, ARBuilt 1977 · S/N 17268587 N733VSClemson Flying Club Inc · Seneca, SCBuilt 1977 · S/N 17268588 N733WCDrouin Roger R · Naples, FLBuilt 1977 · S/N 17268598 N733WEAirwaves Nsb LLC · New Smyrna Beach, FLBuilt 1977 · S/N 17268600 N733WGMiloud Chad · Fort Worth, TXBuilt 1977 · S/N 17268602 N733WHFritts Paul D · Southworth, WABuilt 1977 · S/N 17268603 N733WLShadduck James N · Annandale, MNS/N 17268606 N733WMNakamura Hajime Trustee · Long Beach, CABuilt 1977 · S/N 17268607 N733WSAirgo Inc · Centralia, ILBuilt 1977 · S/N 17268612 N733WTAnderson Aviation Services Inc · Carlsbad, CABuilt 1977 · S/N 17268613 N733WUAviator Air Flight School LLC · Grand Prairie, TXBuilt 1977 · S/N 17268614 N733WVRatzlaff Jeff DBA · Langdon, NDBuilt 1977 · S/N 17268615 N733WWFm Aviation Inc · Concord, CABuilt 1977 · S/N 17268616 N733WXSpartan Marine Co · Capistrano Beach, CAS/N 17268617 N733WYFlys And Floats C172 LLC · Panama City Beach, FLS/N 17268618 N733XMiddleton Mary David · Austin, TXBuilt 1967 · S/N 680045 N733XBBlair Burkholder Inc · Erie, COBuilt 1977 · S/N 17268621 N733XDRoadrunner Bus LLC · Weston, NES/N 17268623 N733XEAeroventures Flying Club Inc · Lilburn, GABuilt 1978 · S/N 17268624 N733XFBeaugez Gregory C · Perkinston, MSBuilt 1977 · S/N 17268625 N733XKSabol Edward J Trustee · Leominster, MABuilt 1977 · S/N 17268629 N733XLAirspeed Marketing LLC · Phoenix, AZBuilt 1977 · S/N 17268630 N733XMRoatis Calin V · Sacramento, CAS/N 17268631 N733XNFlyn Go LLC · Spring, TXBuilt 1977 · S/N 17268632 N733XXHann Bruce E · Athens, OHS/N 17268641 N733XYRuss Micheal · Greer, SCS/N 17268642 N733XZ3650 Aircraft Inc · Bakersfield, CABuilt 1977 · S/N 17268643 N733YBZulu Aerospace Services LLC · Peoria, AZBuilt 1977 · S/N 17268645 N733YCWings Over Texas Holdings LLC · Denton, TXS/N 17268646 N733YEDiederich Fred H · Fayette City, PABuilt 1977 · S/N 17268648 N733YGLeaschauer Eitan · San Jose, CABuilt 1977 · S/N 17268650 N733YHBailey Gordon J · Fayetteville, GABuilt 1977 · S/N 17268651 N733YKLdac Properties LLC · Fresno, CAS/N 17268653 N733YPMiller Robert · Battle Creek, MIBuilt 1977 · S/N 17268657 N733YRBoccaccio Donald O · Hypoluxo, FLBuilt 1977 · S/N 17268659 N733YTRegistration Pending · Centereach, NYRegistration pendingBuilt 1977 · S/N 17268661 N733YVSluka Christopher J · San Diego, CAS/N 17268663 N733YYTetrault Howard D · Malabar, FLBuilt 1977 · S/N 17268666

Back to AD 80-25-07 R1